1) alter your formula
=IF(ISERROR(your_formula),"", your_formula)
example
IF(ISERROR(A1/B1),"",A1/B1)

2) use conditional formatting to hide #VALUE
suppose the cell is B5; then use formula in conditional formatting
=ISERROR(B5) and set the font color the same as the cell background thereby
making it invisible (except when the cell is selected) .

Method 1 is best if you are printing the worksheet
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

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