banner_ad

Ms excel 2007 bug

Excel for Finance 1019 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
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
14 May 2026
Senior Associate

ABHISHEK SHANKAR AGARWAL & ASSOCIATES

Kolkata

CA

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details