View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Newbee Newbee is offline
external usenet poster
 
Posts: 33
Default Covert Number to date

I have a spreadsheet with 20071123 is in number format. I am trying to
covert it so that excel will see those numbers as a date. It is not text but
in number format. How do I change this to make it read 11/23/2007