1
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?
1Thanks! That will help me avoid future problems but is there any way of changing the affected document? In particular is there any way of fixing it within a Windows version of Excel (I no longer have access to a Mac version) – trowel – 2010-11-28T21:30:20.460