Excel 2007 Displays Incorrect Result for 65535

Posts   
 
    
NickD
User
Posts: 224
Joined: 31-Jan-2005
# Posted on: 28-Sep-2007 16:34:56   

Oops! Microsoft formats the result of some multiplications that result in 65,535 or 65,536.

Highlight from the article:

Microsoft wrote:

...that the bug isn't in Excel's calculations, but in code that takes values and formats them to be displayed in the worksheet. To prove that Excel knows its multiplication tables, he suggested entering 850*77.1 in Excel 2007 -- yielding the incorrect 100,000 -- then multiplying the result by 2. The spreadsheet will return the right value, 131,070, not 200,000.

...is that supposed to make me feel better, or worse?