First post - thanks in advance for helping out.

I have a spreadsheet that automatically feeds in values from an external database. I'd like to replace any incoming cells of "#N/A N/A" with "0," and I can't apply any formula to the specific cell because the data import overwrites it with either a numerical value of "#N/A N/A." Please note: this isn't an Excel derived error, but a text-based error message inputted from the database. Excel doesn't recognize it as anything other than a string of arbitrary letters.

I've figured out how to do the opposite: I click conditional formatting, apply new rule, and use a formula to determine which cells to format. I input =A1=0, and the go to custom format and enter [=0]"#N/A N/A" . This works - if I enter a "0," I end up with my text. I'd like to do something like this, but the other way around.

Any ideas?

Best.