Ms excel 2007 bug

Excel 779 views 3 replies

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.


 

Replies (3)

Thanks for showing the bug.

Mine is Fine..Thanks for sharing..

One ????????????? why above one line is repeated again can anyone explain to i.e.

25500.00 x 2.57 = 100000.00 65535.00

 

25500.00 x 2.57 = 100000.00 65535.00


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register