I have an excel spreadsheet containing a column of dates.
When data is copied from other spreadsheets into this spreadsheet the dates change and become inaccurate.
Changing the format of the problematic column from "date" to "number" reveals the data being copied across is correct. It turns out the new spreadsheet displays dates calculated from 1904-01-01 instead of 1901-01-01.
How do I remedy/prevent this?