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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transform calendarized data 4
Duplicating Cell to another cell if it contains data 4
Copy & Paste 1
Find Period Date? 5
matching a column of numbers to another in another spreadsheet 1
PLEASE HELP??? copy every other cell value to a range of cells 3
Date Stamp 7
how to make a table to row column 7

Top