Microsoft has identified an odd bug in Excel 2007 that incorrectly displays 100,000 as the multiplication result in a cell when the answer should be 65,535 or 65,536.

Microsoft employee David Gainer wrote in a posting on the Microsoft Excel blog that calculations such as 77.1*850 and 5.1*12,850 produce the wrong result of 100,000 instead of 65,535. That happens with 12 specific calculations. However, the answer is correct with some other computations, such as 65,535*1 and 16,383.75*4.

Register or login for access to this item and much more

All Accounting Today content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access