Select the range to fix (include other cells if you want).

Edit|Goto|special
check formulas and errors
(and uncheck all the other options)

The selection should be just the cells with formulas that evaluate to #n/a's.

Now type 0 and hit ctrl-enter.

======
Another option would be to change the formula that returns the #n/a.

=if(isna(yourformula),0,yourformula)


Charlie_Brown wrote:

I have a large spreadhsheet (21k rows) that creates alot of #N/A as designed.
I would like to change the #N/A to zero removing the formula. This is not a
one time deal as I need to re-create the spreadsheet weekly. I do not want
to value out the entire spreadsheet.

--

Dave Peterson