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

On May 7, 2:15*pm, Mike Davis
wrote:
How do have Excel default the #n/a to display a zero by using a MACRO
--
Mike Davis