• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

Pasting Formatted Value Into New Cell, Not Underlying Value

I have an Excel 2007 spreadsheet with a column of dates (example: 02/12/2014). I have formatted that column to reflect the day of the week, (ie. Mon, Tue, ...) I now want to copy the formatted value only and paste it into a new column. I don't want the underlying date to be part of that new column, just the day of the week.

How do I accomplish this?
0
JJENSEN3
Asked:
JJENSEN3
  • 3
  • 2
1 Solution
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
Use Paste special
click on values only
0
 
Dan CraciunIT ConsultantCommented:
You can use a formula.
=TEXT(A1, "dddd")

where A1 is a cell that contains your formatted (or unformatted, doesn't matter) data.

HTH,
Dan
0
 
JJENSEN3Author Commented:
Using "values only" still leaves the underlying (02/12/2014) as the value in the cell. The display is correct, but I need the value to be the day of the week as well.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Dan CraciunIT ConsultantCommented:
@Raheman Mohammed Abdul: in this case, Paste Special->Values will get you the numeric value of the date. Not the day of the week.
0
 
JJENSEN3Author Commented:
Works perfect. Thank you.
0
 
Dan CraciunIT ConsultantCommented:
Glad I could help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now