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