View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris M.[_3_] Chris M.[_3_] is offline
external usenet poster
 
Posts: 15
Default Hiding null sums

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?