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
Thanks
Any assistance would be greatly appreciated.
Frank Patrinicola