=IF(ISERROR(formula),"",formula)

--
HTH

Bob Phillips

"Arturo" wrote in message
...
Hi,
I have inherited a file.
There are numerous types of formulas displaying #VALUE! That I want
displaying nothing instead of #VALUE!. I'm searching help files but am
not
find a catch all control to key in. Research suggestions appreciated.

Sincerely,
Arturo