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

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

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.

"Bob Phillips" wrote:

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

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)


"Nicole" wrote in message
...
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.

"Bob Phillips" wrote:

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

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

Bob Phillips wrote:

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