Date changes when copying to a new workbook

[Guest]

Dates are entered in an existing workbook hardcoded using the date format (no
formula). When I copy this sheet into a new workbook, all dates change to a
date 4 years and 1 day earlier then what was previously entered. I have
copied many worksheets and this is the first time I have seen this happen.

 

[Guest]

Your original sheet was set to use the 1904 Date System. This is an option
that can be set in TOOLS-->OPTIONS-->CALCULATION Tab.

Here's more info that may help:

http://support.microsoft.com/kb/180162/en-us

HTH,
Elkar