Date changes from copy to paste

  • Thread starter Thread starter Nathan
  • Start date Start date
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?
 
Compare the workbook options of both workbooks under
Tools>Options>Calculation> '1904 date system'
 
Back
Top