I had the same problem. I had to format the cell as "General" and then it
worked. I'm not sure if it's a bug or what, but try that.

"SNIsRetired" wrote:

I'm using Excel 2003 and am trying to compare columns to find out which of
the items are missing. I'm using the formula:

-ISNA(MATCH(D2,$I$2:$I$6035,FALSE))

Instead of returning true or false entries (or a formula error), it leaves
the formula in the cell. I've tried everything I could to make it work and
it won't. I built a test spreadsheet to try it and it works, but with the
real data it doesn't. Can someone tell me what I'm doing wrong?

Thanks.