Weird Multiplication!
Only happens in Excel 2007.
I've tried it in XP too and it seems to work there.
"Otto Moehrbach" wrote:
I get the right answer in XP (2002). Does this happen in every file? Open
a new blank workbook and try it there. HTH Otto
"Gary T" wrote in message
...
I've just entered into Excel:
=77.1*850
and the answer I get is 100,000, when I clearly shoudl be getting 65,535.
What's happened?
Even if I enter:
77.1 in cell A1 (which Excel stores as 77.1 in number format)
850 in cell A2 ( "" ""
)
And then, in A3, enter:
=A1*A2
I still get 100,000!!!!
|