Thread: Suppress Zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Suppress Zero

Hi,
I was wondering if it were possible to suppress or hide the zero in an auto
sum formula, when there are no values entered in the range? To take it one
step further, would it be possible to delay the calculation until the User
selected the cell with the auto sum formula? This is purely for aesthetic
reasons and more of a curiosity than anything else. Thanks.
Mark