EXcel 200o problem

[Marcus]

I have a problem and need your advise asap.
When I try to sum up a few cells that contain decimal number, it turn out to
be a long sequence of number. Please used only the following example to test
on the excel 2000
e.g. -0.55, -1.0 , 1.65 , then sum up the cell using formula like =sum(S1;S3).
it appear as 0.1 but when you copy and paste special this total sum to
another cell,
it appear as 0.099999999999.
Why will such things happen? Is it the excel error? Pls advise

 

[Shane Devenshire]

Hi,

Computers work in binary, we work in decimals

Here is everything you need to know about this issue (and more):

http://support.microsoft.com/kb/78113/en-us
http://support.microsoft.com/kb/42980
http://support.microsoft.com/kb/214118
http://www.cpearson.com/excel/rounding.htm
http://docs.sun.com/source/806-3568/ncg_goldberg.html

If this helps, please cliick the Yes button.

Cheers,
Shane Devenshire