Dates without //

A

asudem

I need to convert a column of dates formatted "yyyymmdd" t
"yyyy/mm/dd". It seems like it should be easy, but it eludes me.

Thanks!
Kathi
 
J

Jason Morin

Excel is most likely not recognizing your data as dates
and thus you can't reformat them. Convert them to
recognizables date with:

=TEXT(A1,"0000\-00\-00")*1

and then format as the formula cells as yyyy/mm/dd.

HTH
Jason
Atlanta, GA
 
T

TK

Assuming the date string is in cell B1 try a formula like:

=DATE(LEFT(B1,4),MID(B1,5,2),RIGHT(B1,2))

HTH,

TK
 
D

Dave Peterson

Another option if the dates are in a column:

Data|text to columns.
choose ymd as the date type and plop it right back where it came from.
 
Top