Kitty wrote:
I've got a column of data, A1:A10. In the cells of this column, I'll
either have numbers or the text #N.A. N/Ap.

I'm trying to build a formula that says if the content of the cell is
#N/A N.A., then populate 0. But if the content of the cell is a
number, show the number.

What I've done, and which isn't working is: =If(IsNumber(A1), A1, 0).
What am I doing wrong and I'm not an excel pro by any means. Thanks
in advance.

I should also mention that #N/A N.A. is the result of a formula that
pulls from another workbook. Thanks in advance for any help you can
offer.