Group of Number to a Date

[Gee]

I have a column of numbers like this:
20020313
20020313
20020314
20030318
20020325
They are dates that I need to be converted to:
3/13/02
3/13/02
3/14/02
3/18/03
3/25/02
How can I get this column to convert?
Thank you in advance for your help.
Gee

 

[Frank Kabel]

Hi
try the following formula
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

 

[Peo Sjoblom]

Sounds like data>text to columns, select the column with the dates,
do data>text to columns, click next twice and under column data format
select date
and YMD from the dropdown, click finish.

 

[Gord Dibben]

Gee

Data>Text to Columns>Next>Next>Column Data Format>YMD>Finish

Now re-format as Custom m/dd/yyyy

Gord Dibben Excel MVP