# Discussion on: Tip: Excel 2007 has interesting bug

6

### Join the conversation!

View:
Show:
###### Excel 2007 can't display
SWThomas 28th Sep 2007
The problem has been extensively discussed in the blogosphere. It turns out it is a display problem, not an arithmetic problem.

It is detailed here:

blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx

Here's the nub of it:

Of the 9.214*10^18 different floating point numbers that Excel 2007 can store, there are 6 floating point numbers (using binary representation) between 65534.99999999995 and 65535, and 6 between 65535.99999999995 and 65536 that cause this problem. You can?t actually enter these numbers into Excel directly (since Excel will round to 15 digits on entry), but any calculation returning one of those results will display this issue if the results of the calculation are displayed in a cell.

They emphasize that this is *only* (:-?) a display problem. The number is calculated and stored correctly, but displayed incorrectly.
Contributr
###### I've been following it too
ssharkins@... 28th Sep 2007
I read that discussion soon after reading the article I linked. I've seen a number of discussions and the idea that it's "only" a display problem is odd -- if I sent such a number to a check run, it certainly would matter.
###### Office Watch Info
MJGunther 3rd Oct 2007
Office Watch has documented this problem (and that it is *more* than a mere display problem) extensively. See the link below for demonstration and discussion.

EXCEL'S PROBLEM WITH 65,535 & 65,536
###### Excel Error
dion1030@... 3rd Oct 2007
Not only does the EXCEL error on many other numbers for multiplication, the conditional formatting behaves as if the correct number is being displayed as well.

It seems likely that when they fix the the bug, this will remedy itself... hopefully.
Contributr
###### Fix is in...
ssharkins@... 14th Oct 2007
###### RE: Tip: Excel 2007 has interesting bug
farrell_av3 22nd Sep 2010
My excel column letters have changed to numbers how do I change it back to letters.
Keyboard Shortcuts:
Prev
Next
Toggle
###### Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
• [b] Bold [/b]
• [i] Italic [/i]
• [u] Underline [/u]
• [s] Strikethrough [/s]
• [q] "Quote" [/q]
• [ol][*] 1. Ordered List [/ol]
• [ul][*] · Unordered List [/ul]
• [pre] Preformat [/pre]
• [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.