Microsoft Excel
A flaw in Excel 2007 causes certain numbers to be displayed incorrectly

Excel 2007 fails maths test

Spreadsheet software displays incorrect numbers

Shaun Nichols in California

Microsoft has admitted to a flaw in Excel 2007 which causes certain numbers to be displayed incorrectly.

The problem occurs when Excel attempts to display 65,535 or 65,536. Rather than displaying the actual number, the cell instead shows the value at 100,000.

Advertisement

The number 65,535 often appears as a maximum value in computing operations because it is the highest number which can be represented as a 16-bit unsigned number.

Excel group programme manager David Gainer assured users in a company blog that, while the number in the cell is incorrect, the value stored in memory will be accurate and will not throw off further calculations.

Gainer said that the issue occurs when any of six floating point numbers are displayed, and attributes it to "changes to the Excel calculation logic" made during what Gainer terms "the Office 2007 time frame".

A fix is in the final stages of testing, but Gainer would not give an expected date for release. Other versions of Excel are not affected.

  • Have your say
  • Send to a friend
  • Print
  • Digg
  • Reddit
  • Share

Tags:

Do you agree?

Related whitepapers

Related jobs

Most watched

iPhone

Video Review: iPhone 3GS

We put Apple's latest iPhone through its paces

V3.co.uk weekly debrief, 5 Feb 2010

This week we cover the continuing controversy surrounding the Orange T-Mobile deal

Analysis and Reports

Using managed services to protect mobile data users from the latest security threats

Counting the cost of data security: the benefits of secured mobile services

Shifting Disaster Recovery targets with SharePoint and SQL server configurations

Using a hostbased recovery system for mission-critical systems

Poll

Adobe Flash poll

Adobe Flash poll

Do you agree with Steve Jobs about Flash being buggy?

View poll results

Advertisement

White paper library

Keep up to date with the latest products, services and technologies from the world's leading IT companies; IThound.com brings you over 6,000 white papers, case studies and analyst reports.

Advertisement

Newsletter signup

Sign up for our range of FREE newsletters:

Existing User

Newsletter user login:

Enter email address to edit your newsletter preferences

Job of the week

Search thousands of IT jobs :

Search thousands of IT jobs:

Advanced search

Hiring now on ComputingCareers:

Related IT jobs

Search thousands of IT jobs :

Search thousands of IT jobs:

Advanced search

Advertisement

Spotlight

Windows 7

Microsoft denies Windows 7 battery problems

Replacement warning functioning normally, claims software giant

Safer Internet Day

Safer Internet Day highlights online threats

Annual initiative warns of phishing, ID theft and social network...

AMD Fusion

AMD details Fusion innovations at ISSCC

Forthcoming chip with four CPU and one GPU cores will...

MSI Wind U135

Review: MSI Wind U135 netbook

A decent netbook incorporating the latest Intel technology in a...

Primary Navigation