Hi
not sure this is what you want, but change your formulas in the
specific cells to
=IF(ISNA(your_formula),0,your_formula)

HTH
Frank

Is it possable to change all #N/A errors to 0 globally?

Even by the each cell would be fine.

However, once data (numeric) is inserted the data must show and not
the "0"