View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
 
Posts: 272
Default Dates not showing up as dates

I have a file that was exported somehow from another program and some of my
dates are showing up as a negative number. ie...-620589, -617597. I believe
that these dates were not entered with the correct year so when they were
exported Excel did not read them correctly. Is there a way to tell what the
dates should be so I can correct them?