Inaccurate dates displayed in Excel (dates being calcuated from 1904 instead of 1900)

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?

trowel

Posted 2010-11-28T13:42:46.133

Reputation: 113

Answers

2

Somewhere you have a Mac version of Excel involved. Its default start date (or at least an earlier version default is 1904)

You can change the date preferences in Mac Excel to start from 1900

Note Windows Excel dates are actually calculated from 1899-12-31 not 1900-01-01 as Excel copied Lotus 123 and the original programmers thought 1900 was a leap year.

user151019

Posted 2010-11-28T13:42:46.133

Reputation: 5 312

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

Asked: 2010-11-28T13:42:46.133

Viewed: 424 times

Active: 2010-11-28T14:04:39.717