JJENSEN3
asked on
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?
How do I accomplish this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
@Raheman Mohammed Abdul: in this case, Paste Special->Values will get you the numeric value of the date. Not the day of the week.
ASKER
Works perfect. Thank you.
Glad I could help!
click on values only