Hiding null sums

  • Thread starter Thread starter Chris M.
  • Start date Start date
C

Chris M.

I have a spreadsheet that calculates sums across a varying
number of columns. The problem is that when there is no
data in the cells, I get a display of ########. This
doesn't look too pretty on paper, and I'd like to get rid
of unused Sums, or at least hide the pound signs. Any
suggestions on how to do this?
 
Chris M. said:
I have a spreadsheet that calculates sums across a varying
number of columns. The problem is that when there is no
data in the cells, I get a display of ########. This
doesn't look too pretty on paper, and I'd like to get rid
of unused Sums, or at least hide the pound signs. Any
suggestions on how to do this?
Click to expand...

Search Excel help for # and you will see that :
A ##### error value occurs when the cell contains a number, date, or time
that is wider than the cell or when the cell contains a date and/or time
formula that produces a negative result.
If the cells are indeed blank as you say, the result should be 0.

Bob L.
 
You are correct. My formulas were wrong, and now they
display a "-". Any help in removing these would also be
appreciated. Thanks in advance.
 
Chirs,
Create a custom format by right clicking on the cell and picking format
cells. Then in number tab pick custom and roll your own there (see Excel
help for more about custom formats). For example you could use this as the
custom format:

#,##0_);[Red]General;""

(It sets the format for positive numbers;negative numbers; zero. The "" is
a zero length string meaning show that when the result is zero. I think that
is what you want)

Bob L.
 
Back
Top