I am not aware of an elegant way but I know of two work-arounds.

Option 1. Apply conditional formatting to the cell by selecting "Formula
Is" and typing "=ISERROR(A1)" where A1 represents the current cell. Format
the cell to use the white font color (or whatever color your sheet's
background is) when the condition is met.

Option 2. Trap for the error in the formula itself, such as
"=IF(ISERROR(A1/B1),0,A1/B1)". You can then apply your custom format that
hides zero values.

Both options add quite a bit of overhead to the file, so I would not
recommend using them often in heavy duty financial model or the like.

HTH
Kid Jones

"rlugood" wrote:

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