Thread: 0% = blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 0% = blank

Menu ToolsOptions and on the View tab, uncheck the Zero Values box.

--
HTH

Bob Phillips

"broogle" wrote in message
oups.com...
Is there any format to make the cell equal to blank if the value = 0%.
Thanks