Hi

Sounds like the cell was preformatted as Text.
Format the cell as General, edit the formula with F2press Enter

--
Regards
Roger Govier



"mrp" wrote in message
...
when entering
=COUNTA(C9:C78) into a cell to count the non blank cells the formula is
displayed instead of the count.

Any suggestions as to how to resolve the problem would be appreciated
--
Al