View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tazman2168 tazman2168 is offline
external usenet poster
 
Posts: 1
Default HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM

I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any
way to make the cells blank until actual data is input without clearing the
cell of the SUM command?