Concerting the #Value! to zero 0 or hyphen (-)

August 1, 2012 at 06:57:01
Specs: Windows 7
I have columns which cannot calculate and they are giving me the output #VALUE! in excel as shown below, for some it calculates.

So I want the cells with the #VALUE! to show a Zero (0) or a Hyphen (-)

See More: Concerting the #Value! to zero 0 or hyphen (-)

Report •

August 1, 2012 at 11:51:32
Rather than hiding the error, why not fix it? In most cases, hiding an error is dangerous because you may end up masking an error that you should be aware of.

For example, if any of your calculations actually end up being 0, how would know which ones were valid and which ones were errors?

Share your formula and input data and perhaps we can offer a suggestion on how to eliminate the error.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question