In Excel ### appears in the cell, not the sum. Why?
 

I am using the sum formula to sum across rows. The formula works, but for
one set of calculations the actual sum does not appear in the destination
cell, only a series of ####. How can I get the actual sum to appear? This
is only occuring for 1 set of the calculations. All others work

In Excel ### appears in the cell, not the sum. Why?
 

Trying increasing the column width (position your cursor up in the column
header -- on the right edge and double click... or click and drag.

Or with the column selected, go to Format -- Column Width and increase the
number until your data displays completely.

Kathryn Groves
MOUS - Office 2000


"BYT" wrote in message
...
I am using the sum formula to sum across rows. The formula works, but for
one set of calculations the actual sum does not appear in the destination
cell, only a series of ####. How can I get the actual sum to appear?
This
is only occuring for 1 set of the calculations. All others work