Binary? Decimal? Excel 2007 finds it all so confusing

Excel 2007 has troubles with multiplication when the result is 65,535--a number familiar to those who've dealt with binary numbers.

Microsoft on Tuesday confirmed a bug in Excel 2007 that can cause it to produce erroneous answers for a particular multiplication task.

Specifically, the problem can crop up when the answer to a multiplication problem should result in 65,535. You fans of binary arithmetic don't need to be told that's 2 to the 16th power minus one, or maximum integer that can be described with two bytes, counting up from zero. So it's a good bet some binary-to-decimal translation is involved in the problem.

A repair is in the works, Microsoft said, without sharing much more in the way of detail.

"We are currently in the process of developing and testing a fix for the flaw," Microsoft said in a statement Tuesday. "Microsoft places a high priority on quickly responding to customer feedback, and we are committed to finding ways to provide a better software experience."

News of the bug surfaced Saturday on an Excel mailing list, and Slashdot picked it up Tuesday. The latter forum, with a disproportionate population of Microsoft bashers, gleefully pounced on the problem.

One commenter said Microsoft's fix will offer a new rendition of the hated Clippy: The fix will trigger the appearance of "an animated sprite of Charles Babbage's head," who will say, "It looks like you're trying to multiply two numbers. I can help show you how to use the Method of Finite Differences to find a good approximation of your answer using only addition and subtraction. Would you like me to bring up a wizard so that we can get started on finding an appropriate power series?"

Another commenter was more constructive, observing that even when the problem crops up, the correct results are placed in a graph.

Featured Video
This content is rated TV-MA, and is for viewers 18 years or older. Are you of age?
Sorry, you are not old enough to view this content.

Details about Apple's 'spaceship' campus from the drone pilot who flies over it

MyithZ has one of the most popular aerial photography channels on YouTube. With the exception of revealing his identity, he is an open book as he shares with CNET's Brian Tong the drone hardware he uses to capture flyover shots of the construction of Apple's new campus, which looks remarkably like an alien craft.

by Brian Tong