How can I eliminate this error in excel by replacing it with 0 (zero) using find/replace or whatever you think is best suited.
If you are using Excel 2007 and beyond and have a formula, you can use:
something like iferror(if(value,0))
CTRL plus H will take you to find and replace page, then type on the top row #value and below row replaced with 0 and press replace all.
Or (? pre 2007 but still works)
=IF(iserror(your formula)="false",your formula,0)
These work for any error but beware because it can hide things that you should be checking!
You CAN use =IF(iserror(your formula)="false",your formula,"ERROR") which will highlight any errors but still enable the column(s) to add up.
This will highlight any errors but still enable the column(s) to add up.
THIS IS NOT DISPLAYING HOW IT LOOKS IN EDIT!!