#n/a

[Mike Davis]

How do have Excel default the #n/a to display a zero by using a MACRO

 

[John Bundy]

You dont have to use a macro for this, wrap your formula in a isna:
if(isna(formula),"0",formula)

basically the same thing if you do it in a macro.

 

[Pete_UK]

If the #N/A is caused by a lookup or match formula, then you can do
this to your formula:

=IF(ISNA(your_formula),0,your_formula)

Hope this helps.

Pete