Date changes from copy to paste

N

Nathan

I copy a date cell (let's say 12/9/09) from one spreadsheet and when I paste
it into another spreadsheet, it goes to 12/9/13. What!? Any clue as to why it
would be adding 4 years to the date?
 
J

Jacob Skaria

Compare the workbook options of both workbooks under
Tools>Options>Calculation> '1904 date system'
 
Top