Try formatting the cell (right clickformat cells) as general, or as number,
then re-enter the formula.


"Jamie" wrote in message
...
I'm using the "CountA" formula throught my spreadsheet, and it works fine
in
all cells but one - in which the formula displays as text. I've reset
Tools,
Auditing, copied formatting from cells that display correctly, and copied
the
formula from cells that display the result. Nothing is working.