View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary T Gary T is offline
external usenet poster
 
Posts: 21
Default 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!!!!