Thread: Is there anyway to hide #DIV/0! in an excel worksheet cell.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rlugood rlugood is offline
external usenet poster
  
Posts: 2
Default Is there anyway to hide #DIV/0! in an excel worksheet cell.
I learned how to hide a zero by entering in 0;-0;;@ in the custom format
area. I would like to know if there is anyway to hide #DIV/0! until a valid
number is calculated. Thanks
Reply With QuoteReply With Quote