Wao, this will be the best bug, hopefully they can fix it in SP1. I have try multiply 850 by 77.1 in Excel 2007 + Autopathcer Office 2007 August 2007 and still got the 100.000.
It seems Excel 2007 also can't calculate 840*78.0178571428571428571428571428571 but correctly reports 65535 for 840*78.017857142857142857142857142857 (dropping the last decimal). Evidently the bug is smart enough to affect only calculations that produce "exactly" 65535.
"65535 is a frequently occurring number in the field of computing because it is the highest number which can be represented by an unsigned 16 bit binary number."

http://en.wikipedia.org/wiki/65535_(number)
@Raj:
Actually, in Excel 2007, rows end at 1,048,576.
This is a freshman year programming mistake. Is quality control so lacking at Microsoft these days that they don't even test for overflows?
The article is talking about Excel 2007 you numpty.
Wao, this will be the best bug, hopefully they can fix it in SP1. I have try multiply 850 by 77.1 in Excel 2007 + Autopathcer Office 2007 August 2007 and still got the 100.000.
If you read the article carefully, they are talking about Excel 2007
Excel rows end on the very next number 65536 - wonder if thats got something to do with it
It seems Excel 2007 also can't calculate 840*78.0178571428571428571428571428571 but correctly reports 65535 for 840*78.017857142857142857142857142857 (dropping the last decimal). Evidently the bug is smart enough to affect only calculations that produce "exactly" 65535.
when you calculate 850 * 77.1 and then from the result subtract 2 you get what looks like...
1000000 - 2 = 65533...
"65535 is a frequently occurring number in the field of computing because it is the highest number which can be represented by an unsigned 16 bit binary number."

http://en.wikipedia.org/wiki/65535_(number)
And if you multiply 77.1*850 you get 5052748.5. Put 850 in on cell (A) and 77.1 in another (B). Try A*B and B*A.
My Excel 2003 has 850*77.1 equaling 65,535. Might already be patched?!?!