Incorrect dates when copying to a new workbook??

C

Corey

Hello. I'm hoping someone else has encountered this
problem and knows how to fix it. I'm working with some
older spreadsheets that have continually been updated for
many years now. When I try to copy the sheet to a new book
or just copy the cells of dates and paste them into a
different workbook, the dates are behind by exactly 1,462
days. For example, I'll copy 12/31/03 into a new work book
and it will appear as 12/30/99. How do I fix this?

Thank you!

Corey
 
N

Norman Harker

Hi Corey!

You appear to have your new setting at the 1904 date system:

Use:

Tools > Options > Calculation
Uncheck "1904 Date System"
OK
 
Top