View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.