lExcel incorrectly multiplies 850 * 77.1

Excel incorrectly multiplies 850 * 77.1



Isn't that just dandy.

No, it does not.

If you're talking about the Excel 2007 bug (which doesn't have a darn thing
to do with Vista) it's a display bug. It mistakenly displays 100,000
instead of 65,535. If you reference that result in another cell with
another function, the correct result is shown.

And Microsoft knows about it and a fix is already being tested.

--
Richard G. Harper [MVP Shell/User]
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm


"Vista User" <> wrote in message
news:fdh9qt$d57$...
> Excel incorrectly multiplies 850 * 77.1
>
>
>
> Isn't that just dandy.
>
>

"Richard G. Harper" <> wrote in
news::

> No, it does not.
>
> If you're talking about the Excel 2007 bug (which doesn't have a darn
> thing to do with Vista) it's a display bug. It mistakenly displays
> 100,000 instead of 65,535. If you reference that result in another
> cell with another function, the correct result is shown.

That is not entirely correct. Apparently there are instances in which the
bad number will be used and saved......

http://veroblog.wordpress.com/2007/0...lculation-bug-
displays-apparently-wrong-numbers/

More than half way down, a paragraph starts...

'As long as you handle the numbers within Excel, they work properly and
simply display incorrectly.'

And then goes on later....

'A common method is to export to a CSV file which can then be imported
into another program (often a database which cannot read and write to
Excel files directly). CSV files will also carry the incorrect display
figure instead of the underlying stored value.'

Apparently using ROUND can also make the bogus number stick.