What happened that I get "-" in a cell

N

Nicole

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
 
B

Bob Phillips

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)
 
N

Nicole

Hi Bob,

Yes, you are right, I did get 0 but the result should have not been 0 as
there was a formula adding up all the numbers above.
 
B

Bob Phillips

That sounds like the cells A1:A12 are formatted as text to me. Reformat
those as well.

--

HTH

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

Jerry W. Lewis

Note that just "changing the format" will not change the underlying
value from text to a number. Copy an empty cell, select A1:A12 and
Edit|Paste Special|Add

Jerry
 
Top