Date conversion

[Newbie]

I also have a column that has dates in the format of:

20031201 which is YearMonthDay and I want to convert them all to December 1,
2003.

Is this possible? Thanks.

 

[Bob Phillips]

=date(left(a1,4),mid(a1,5,2),right(a1,2))

 

[Gord Dibben]

Data>Text to Columns>Next>Next

Column Data Format>Date>YMD>Finish


Gord Dibben Excel MVP

 

[Newbie]

Cool, step one complete.