Dates without //

[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

 

[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

 

[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

 

[asudem]

TK, you are the best! Thank you very much

 

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