Handles Dates in 19th Century Wrong

[Jerry Malone]

I have been working with an Excel sheet that I need to
enter 19th century dates. When you enter a date as an
example: 3/4/1897, the cell will not format correctly.
When I try to import this data to Access I get errors for
dates that are in the 19th century. Any ideas?

 

[Hank Scorpio]

I have been working with an Excel sheet that I need to
enter 19th century dates. When you enter a date as an
example: 3/4/1897, the cell will not format correctly.

Excel's date numbering system starts from 1/1/1900, or 1/1/1904 for
Mac users.

When I try to import this data to Access I get errors for
dates that are in the 19th century. Any ideas?

You may be able to use this to help overcome the problem:

http://j-walk.com/ss/excel/files/xdate.htm

 

[Hank Scorpio]

Excel's date numbering system starts from 1/1/1900, or 1/1/1904 for
Mac users.

Point of clarification, not that anyone is likely to care much; the
1904 Mac system recognises recognises 0 as a valid date (that being
1/1/1900), whereas the Windows 1900 based system doesn't. Consequently
it could be argued that the 1904 system starts from 2/1/04, which is
the first non-zero value.