One way is to put a conditional format and look for

=ISERROR(A1)

where A1 is the cell of interest. You can change the font to white.
Alternatively, you could put

=if(iserror(Your formula),"",Your formula)
--
HTH,

Barb Reinhardt



"dwolf" wrote:

Is there a way to hide the "#value!" so it does not show in the cell?