Ms excel 2007 bug

Excel 992 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  

Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details