Your formula worked ok for me.

Are you sure you have calculation set to automatic?
tools|options|calculation tab

If that isn't it, you may want to copy the formula directly from excel into your
followup message.

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/Ap, 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.

--

Dave Peterson