9/26/07

Weird Excel bug

Ok, Try this.
Select the following text and paste it into Excel.

=850*77.1
=5.1*12850
=10.2*6425
=20.4*3212.5
=40.8*1606.25
=77.1*850
=154.2*425
=212.5*308.4
=308.4*212.5
=425*154.2

The answers should be 65535.
Excel says 100000.

Take a look here for more info

Note: It's not a problem for Excel 97. Only for the newer versions.

No comments:

Post a Comment