Date changes back 4 years when copying

D

Dave

When we copy a date from an excel 2000 worksheet and paste
it in an excel XP worksheet the year will move back four
years. Any ideas?
 
A

Alan

Go Tools > Options > Calculation and make sure both files have '1904 Date
System' either checked or unchecked, ie both the same,
Regards
 
J

JE McGimpsey

Dave said:
When we copy a date from an excel 2000 worksheet and paste
it in an excel XP worksheet the year will move back four
years. Any ideas?
Click to expand...

Your XL2000 worksheet is using the 1904 date system
(Tools/Options/Calculate), while your XP worksheet is using the 1900
date system.

Change the workbooks to use the same system.
 
H

Harald Staff

Four years and one day ? One file is set to 1900 calendar (Windows standard)
and the other to 1904 (Mac standard). Settings are in Tools > Options menu.
Add 1462 to the dates to fix them.

HTH. Best wishes Harald
 
Top