That is not an error, just they accounting way of signifying a zero value.

Changing the format should show 0, but if not, do F2 then enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nicole" wrote in message
...
I have simple Sum Functions in my Worksheet and they are all correct.

In one of the Cells I only get a minus "-" sign. But the formula in the
cell
is correct! =Sum(A1:A12). When I check the formatting under Format Cells I
see that the Format is "Accounting" but even if I change it back to Number
or
Custom it doesn't make a change. I can only fix it by copying another Sum
Formula and paste it using Paste Special - Value.

However, this starts to annoy me now. Why is this happening or what am I
am
doing wrong that I get those errors in my formulas? Any ideas?

Nicole