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?

Dates not showing up as dates
 

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.

"Lori" wrote in message
...
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?

Dates not showing up as dates
 

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

"Lori" wrote in message
...
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?