Using find and replace to change #n/a to other value

[Fizzz]

Hello all,

Is this possible? I find myself usually ending up changing the values one by one. Is there a way of using the find/replace (ctrl+h) to look for the #N/A error and replace it with say just the number zero?

All the best :D

 

[buxtongt]

It would probably be easier to add something to the formula that is giving you that result (assuming it is a formula). Search around on error handling or removing errors on the forum, there should be plenty of posts about it.

 

[MrVillareal]

Hello all,

Is this possible? I find myself usually ending up changing the values one by one. Is there a way of using the find/replace (ctrl+h) to look for the #N/A error and replace it with say just the number zero?

All the best :D

try,

Home tab-->find and select-->go to special-->formulas then uncheck numbers,text,logical and the remaining is errors.

Be sure not to select any cells before doing it. It will select all the errors not just NA() then type 0 then CTRL ENTER

 

[JoeMo]

Hello all,

Is this possible? I find myself usually ending up changing the values one by one. Is there a way of using the find/replace (ctrl+h) to look for the #N/A error and replace it with say just the number zero?

All the best :D

1) Press the F5 key to open the Go To dialog box
2) In bottom left corner click Special
3)Select Formulas and uncheck all but the Errors box
4)click OK
5)Type a 0
6)Hold down the ctrl key and press Enter

 

[Fizzz]

1) Press the F5 key to open the Go To dialog box
2) In bottom left corner click Special
3)Select Formulas and uncheck all but the Errors box
4)click OK
5)Type a 0
6)Hold down the ctrl key and press Enter

Right what I was looking for thanks!

Of course I could add something to the formula... but this is awesome