excel changing dates by 4 years and a day

[Gary F Marsh Jr]

I have had this problem for about 4 or 5 years. I will copy dates that
are correct then it pastes them but excel changes the dates by 4 years
and a day earlier. So 2/14/2003 changes to 2/15/1999. Any one ever see
this or know how to stop it from happening? I have hours and hours of
reentering of information if there is no solution.

Thanks

 

[Tom Stiller]

I have had this problem for about 4 or 5 years. I will copy dates that
are correct then it pastes them but excel changes the dates by 4 years
and a day earlier. So 2/14/2003 changes to 2/15/1999. Any one ever see
this or know how to stop it from happening? I have hours and hours of
reentering of information if there is no solution.

Thanks

Open one of the incorrect worksheets and then check, or uncheck as
appropriate, the "1904 date system" box in the Preferences->Calculation
pane.

 

[Gary F Marsh Jr]

ty