View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default I want to see blank cell rather to see #DIV/0!

Post an example of your formula that returns #DIV/0!

--
Biff
Microsoft Excel MVP


"Harshad" wrote in message
...
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