Dates not showing up as dates

[Lori]

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?

 

[Fred Smith]

The way to tell what they should be is to check the original export file.
Without that, your guess is as good as ours.

Regards,
Fred.

 

[Ashish Mathur]

Hi,

A -ive number implies a date prior to 1 January 1900 which is not supported
in Excel. So I do not think you can know the date. However, if you have
any +ive'd date equivalenet can be determined by using
=text(cell_ref,"dd/mm/yyyy")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com