Converting Number to Date
I have a file that I regularly download from a mainframe system. In the
file, dates come across as numbers in a MMDDYY format (example, May 31, 2007
come across as 53107; November 15, 2007 is 111507).
How can I change these numbers to a correct date format in Excel?
Thanks
Bill
|