Excuse me smart a**e but I did not know about any calculation bug, I'm doing
an audit of a worksheet I produced and couldn't understand why I was getting
this. The worksheet was originally produced in Office XP but last week we
upgraded to Office 2007 and it was then that this materialised.

Thanks for the links (which I can't actually access at work) but as I said
your tone is extremely unhelpful. Not all of us spend all day on these
forums or googling 'Excel 2007 Calculation Bug'.


"Ron Coderre" wrote:

Whoever told you about the Excel 2007 calculation bug should have also
indicated that this is a VERY known issue.
A Google for "Excel 2007 calculation bug" returned almost 2 Million hits.

Of particular interest are the Microsoft confirmation of the bug:
http://blogs.msdn.com/excel/archive/...ue-update.aspx

And the notification that a fix is available:
http://blogs.msdn.com/excel/archive/...available.aspx

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


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