formula is displaying as text rather than result.

[Jamie]

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.

 

[Dave R.]

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

 

[Jamie]

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