Try formatting that cell as General (or anything but text)
then select the cell, hit F2, then enter (to reenter the formula)

If that doesn't work, make sure you're not looking at formulas:
tools|Options|View tab|make sure Formulas is not checked.

Deborah R wrote:

I'm working with game stats. I'm simply trying to count the number of "W"s in
a column as opposed to "L"s. I've entered =COUNTIF(O2:O56,"W"). My result is
the formula rather than the count. What am I doing wrong?

--

Dave Peterson