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
|