number to date formats

[adam]

I have a large spreadsheet with over 60,000 dates in a
column. the problem is that they are in a number format.
ie:
january 1, 2003 is listed as 1012003. excel thinks it is
one million twelve thousand and 3. I tried to change it
to date format but it does not work.

Any ideas?
help!
adam

 

[Felipe I]

The following worked for me:

=date(right(A1,4),mid(A1,len(A1)-5,2),left(A1,len(A1)-6))

I assumed the first 1/2 numbers are day and the following
2 are month. Date syntax is Date(year,month,day). Change
formula if needed

Regards,
Felipe