Change short date to yyyymmdd 1

[AcctSolver]

I need to change a large number of regularly formatted dates in Excel 2007, like 03/08/1997, into yyyymmdd format 19970308. Doing it with the custom format feature is not sufficient, as the actual data needs to be converted to have content saying 19970308.

I did a =year(), =month(), and =day(), then concatenated the result...it works, but there HAS to be a better way. None of the various copy paste specials worked, since I really need to convert the data, not just change how it appears.

 

[SkipVought]

Hi,

In an adjacent column, assuming your date is in column A, starting in row 2...
[tt]
=TEXT(A2,"yyyymmdd")
[/tt]
CAVEAT: These value are no longer DATES!!! Of course, your REAL DATES are in Column A.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]