Is there a number format to get rid of error data?


Posted by John S. on October 19, 2001 9:40 AM

Instead of using a formula. I want to get rid of my #REF! and #N/A



Posted by IML on October 19, 2001 9:58 AM

A really lame possibility

The best solution would be to get rid of those errors. I'm sure you'd have people happy to help if you provide some data.
If you must try formatting, you could go to conditional formatting under the formatting menu and type in the formula
=ISERROR(B2)
if b2 is the cell of interest. If its true, set both the font and pattern to same color. I told it was lame. Another bad thing is this would "hide" any error as all.