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?
JJENSEN3Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Dan CraciunConnect With a Mentor IT 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
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
Use Paste special
click on values only
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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.

All Courses

From novice to tech pro — start learning today.