Negative Zero (-0.00)
=ROUND(A15-B15,2)
--
David Biddulph
"Samuel" wrote in message
...
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.
|