Date changes from copy to paste
 

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?

Date changes from copy to paste
 

Compare the workbook options of both workbooks under
ToolsOptionsCalculation '1904 date system'

--
Jacob


"Nathan" wrote:

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?