Thread: Forcing DIV/0 to display "0"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
Pieter van der Walt Pieter van der Walt is offline
external usenet poster
  
Posts: 5
Default Forcing DIV/0 to display "0"
I have a scorecard in Excel 2003 and instead of having DIV/0 errors
displayed is there a way of actually forcing it to display a zero/null
value? I had a looked at conditional formatting and the example only seems
to be hiding it in a different colour.

Thanks
Pieter


Reply With QuoteReply With Quote