That KB article that Dana posted explains a few reasons why it's not as simple
as a option in Tools|options.

wrote:

"Dave Peterson" wrote:
since Lotus 123 thought that 1900 was a leap year,
that MS had a choice--do it correctly or do it to match
Lotus 123.
By matching Lotus 123's mistake, it would be easier
for users to migrate from 123 to Excel.
And since every company wants users and wants to
make that transition as easy as possible, the decision
was probably very easy to make.

As a developer of system software, I understand the
importance of compatibility. But assuming the explanation
is correct, there should be an option to correct the problem.
The default could remain bug-for-bug compatibility.

--

Dave Peterson

"Dave Peterson" wrote:
That KB article that Dana posted explains a few reasons
why it's not as simple as a option in Tools|options.

I think I fully understand all the issues. I am not in
the habit of giving free consulting to Mr. Gates' boys,
and I would not presume to tell them how to solve
their problems without looking at the code first myself.

However, I think Fred Smith probably got it right.
I hope he rushes out and patents the "elusive"
solution ;-) so that he can get his due from Bill.