Hi Rob

One way:

=IF(ISERROR(Formula),"-",Formula)

Will display a hyphen, if the formula returns an error.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Rob" skrev i en meddelelse
...
Hi

I'm sure this has been asked before but I can't find it in Help or on this
forum. I have many formulas in Excel (2003) where some of them return a
#VALUE, I'm happy with this as I know there is certain data missing.
However, for presentation purposes I do not want to display #VALUE, can I
just display a blank or a zero if the result of a formula is an error???
I've looked at some of the functions available in XL but can't find
anything.

Any help will be appreciated.

Thanks

Rob