Thread: Hiding amounts that equal 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default Hiding amounts that equal 0
Use ToolsOptionsView and uncheck Zero Values

--
__________________________________
HTH

Bob

"Sandi" wrote in message
...
Is there a formula that you can use that says if the amount is 0 nothing
showes in box?
--
Sandi


Reply With QuoteReply With Quote