"Chris M." wrote in message
...
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?

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.