This suggestion has been out here for YEARS - FIX IT NOW for ALL VERSIONS. We
pay enough money for this software. Birth dates and Historical dates go back
before 01/01/1900 and should stored and used the SAME way. I have an Access
db with historical dates then try to copy them or use them in EXCEL and it is
not correct.
Don't even bother suggesting the ADDIN again NO addin should be NEEDED for
dates. IT is totally ridiculous that all dates back in HISTORY can't be used
correctly and the same. OTHER software handles dates with no problem - so
should microsoft office excel in ANY version.


"skoalguy" wrote:

Please update the Excel program to handle dates before 1/1/1900. Currently I
have to enter older dates as strings and then jump through hoops to use them
as actual dates. dBase, FoxPro and heck even Clipper handle pre-1900 dates
without any problem, so why can't a great product like Excel do the same?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc