Discussion Locked

Date change when copying from Excel 2000

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are e-mailing an Excel 2000 spreadsheet around our company. When someone receives the spreadsheet, they cut out the lines they need and paste them to their own spreadsheet or a new spreadsheet. When they do this, the dates change - i.e. 1/14/02becomes 1/13/98, 12/14/01 becomes 12/13/97. It always subtracts 1 day and 4 years from the original date. Any ideas why this happens?

4 replies

by dklippert

Go to Tools>Options Calculations and make sure that the 1904 date system is not checked.
Also go to Help about and see if the machines have been upgraded with SR1 or 1a

This discussion is closed to new replies.