Negative Zero (-0.00)

[Samuel]

Hiya,

Im just doing a spreadsheet and have two columns auto-sumed (A15 & B15 show
totals).

I have a forumla in C15 which is '=A15-B15', yet the answer is coming out as
-0.00 when in actual fact it should be 0.00 (without the negative in front).
Is there a way to fix this as it is messing up other forumla's in the
spreadsheet because it is a negative value and not a 'positive' zero.

Thanks,
Samuel.

 

[Mike H]

Hi,

You'll probably find that the cell isn't zero at all but is showing as zero
because your only showing 2 decimal places.

Try this to eliminate it but be aware it does change the value of the number

=ROUND(A15-B15,2)

Mike

 

[ShaneDevenshire]

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.