View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Samuel Samuel is offline
external usenet poster
 
Posts: 26
Default Negative Zero (-0.00)

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.