Ms excel 2007 bug

G.Siva Shankar ((CA)) (54 Points)

18 December 2013  

Open fresh excel sheet.
Enter in cell A1 =77.1*850 then hit enter.
What is the value shown in A1?
If A1 shows 65535, then there is no problem, carry on your work.
But, if A1 shows 100000, your excel having the bug…, check all the below calculations also.

Actual
77.10 x 850.00 = 100000.00 65535.00
5.10 x 12850.00 = 100000.00 65535.00
10.20 x 6425.00 = 100000.00 65535.00
20.40 x 3212.50 = 100000.00 65535.00
40.80 x 1606.25 = 100000.00 65535.00
154.20 x 425.00 = 100000.00 65535.00
212.50 x 308.40 = 100000.00 65535.00
308.40 x 212.50 = 100000.00 65535.00
425.00 x 154.20 = 100000.00 65535.00
38.55 x 1700.00 = 100000.00 65535.00
10.28 x 6375.00 = 100000.00 65535.00
6425.00 x 10.20 = 100000.00 65535.00
12750.00 x 5.14 = 100000.00 65535.00
12850.00 x 5.10 = 100000.00 65535.00
25500.00 x 2.57 = 100000.00 65535.00
25500.00 x 2.57 = 100000.00 65535.00
25700.00 x 2.55 = 100000.00 65535.00
106.25 x 616.8 = 100000.00 65535.00
803.125 x 81.6 = 100000.00 65535.00
401.5625 x 163.2 = 100000.00 65535.00

If your excel shows as 100000, then try the following solution.
SOLUTION

To resolve this problem, install the latest Service Pack of your Microsoft office version and confirm the
above error solved or not.