MS Excel should handle dates before 1900!
 

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

MS Excel should handle dates before 1900!
 

But John Walkenbach has an addin that will help you:
http://j-walk.com/ss/excel/files/xdate.htm



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

--

Dave Peterson

MS Excel should handle dates before 1900!
 

SO WHAT if there is an addin. Excel should handle ALL dates without having
to use some addin. I had to waste critical work time to handle this. Most
OTHER software handles dates prior to 1900 without a problem, extra thought
or special addins. You are only suggesting having do something special that
should be an intergral part of the software. When someone has to deal with
history and birth dates having to find and use a special unknown addin is
ridiculous.

"Dave Peterson" wrote:

But John Walkenbach has an addin that will help you:
http://j-walk.com/ss/excel/files/xdate.htm



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

--

Dave Peterson

MS Excel should handle dates before 1900!
 

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