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.
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.