Copy Date to Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a long row of dates that are formatted as Date.

I want to copy and past them into a blank cell as text and have them still
look like dates (10/25/07) not long numbers.
 
Insert a helper column and then place the following formula in the newly
minted column

=TEXT(A1,"mm/dd/yyyy")

Copy the formula down the column as far as necessary.

Copy the entire column that has the converted dates and the click EDIT in
the menu and select PASTE SPECIAL. Click the VALUES option button and click
OK and your formulas are now just the results of the formula.

Adjust the cell address and date format to fit your current requirements.
 
Copying and pasting will not turn them into text nor change the underlying
serial number uses for dates.

All I can see is a formula in an adjacent column or wherever you want the text
dates to show up.

=TEXT(A1,"mm/dd/yyy")

When done, copy then paste special>values>ok>esc


Gord Dibben MS Excel MVP
 
Back
Top