View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary T Gary T is offline
external usenet poster
 
Posts: 21
Default Weird Multiplication!

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!!!!