View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
billbrandi billbrandi is offline
external usenet poster
 
Posts: 26
Default 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