Date conversion/sorting problem

[frankpat]

I have a voluminous spreadsheet that I need to sort by date. The problem is how the dates are presented. For example: January 2, 2002 is presented as 1022002. October 2, 2002 is presented as 10022002. Essentially, dates are entered as integers, not in a form which Excel recognizes as dates. Do you know of a way that I could convert the integers to dates?
Thanks

Any assistance would be greatly appreciated.

Frank Patrinicola

 

[Mark W.]

For text representation of date values listed in column A begining at cell A1 enter the formula...

=TEXT(A1,"0-00-0000")+0

...into B1 and fill down. You can then use Copy/Paste Special... Values to overlay the column A values.

...Or, just sort on the new column B values.
This message was edited by Mark W. on 2002-04-24 13:08