Just a Thought.

Try clicking on the cell that is displaying the formula, then press F2.
Next press enter.

Regards,
Paul

"NewKid" wrote in message
...
I work in large Excel data files where I frequently do a "countif" to
compare
account numbers. Sometimes, the "countif" function will result in
displaying
the actual formula in the cell, rather than the result. I have tried to
make
sure the cells are formatted correctly, etc., but nothing works. Any
ideas??