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.

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.

I figured this out for myself. I used Format, Clear, retyped the function,
then reformatted. It worked.

"Jamie" wrote:

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.