View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd
 
Posts: n/a
Default converting date to number

I exported data from a scheduling program to an excel spreadsheet and data is
now formatted as as date instead of a number. What was 4631-01-10 is now
1/10/4631 and if I convert it to text becomes 997488. How do I convert the
data back into its origonal format? (4631-01-10)

Thanks,

Todd