Thread: I want to see blank cell rather to see #DIV/0!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harshad[_2_] Harshad[_2_] is offline
external usenet poster
  
Posts: 44
Default I want to see blank cell rather to see #DIV/0!
Hi all,

I have prepared some calculations, some where i saw the cell cointaining
"#DIV/0!".
i want that the cell cointain formula will see as blank, but not the
"#DIV/0!".
I can remove zero by toolsoptionview window option dont check on Zero
value.

Thank you.
Harshad

Reply With QuoteReply With Quote