=IF(ISNA(blah),"",blah)
=IF(ISNA(blah),0,blah)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Charlie_Brown" wrote in message
...
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.