On May 21, 10:15*am, Dave Peterson wrote:
If the cell contains a formula that returns that #n/a, then edit|replace
(ctrl-h) won't help.

If you want to change all the formulas that return #n/a, you could try this:

Select the range
Edit|goto (or ctrl-g)
Special
Formulas, but only leave Errors checked
(uncheck Numbers, Text, Logicals)
Click Ok.

Now only the cells that have formulas that return errors are selected.

type 0 and hit ctrl-enter to replace those formulas with 0.



Len wrote:

On May 21, 12:47 am, Dave Peterson wrote:
What was the formula you used?

<<snipped

"Ctrl+H" with find what "#N/A" and replace with "0.00"

--

Dave Peterson

Great !, it works.......... thanks

Regards
Len