Data/ Text to Columns/ select Date & MDY at the end of the wizard.
--
David Biddulph

"billbrandi" wrote in message
...
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