Handles Dates in 19th Century Wrong

  • Thread starter Thread starter Jerry Malone
  • Start date Start date
J

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?
 
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.
Click to expand...

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?
Click to expand...

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

http://j-walk.com/ss/excel/files/xdate.htm
 
Excel's date numbering system starts from 1/1/1900, or 1/1/1904 for
Mac users.
Click to expand...

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.
 
Back
Top