October 2007

Excel 2007 calculation bug

You probably already know about this but it’s such an egregious failure that I feel I have to post something about it. Excel 2007 sometimes has problems with the result of calculations in the range of 65,534.99999999995 to 65,535 and 65,535.99999999995 to 65,536. Excel can display the value as ” 100,000 ” instead of the proper value. Microsoft’s working on a fix but I haven’t seen anything so far. This week’s Office Watch newsletter has a decent write-up of it. It’s an email newsletter but a rundown of the failure is available at this link on their news site.

Excel 2007 calculation bug Read More »