did you re-enter the formula? and try the other suggestions you got?
--
Kind regards,

Niek Otten

"Scudo" wrote in message
. uk...
Thanks for reply,

I re formatted the cell A60 as `general` but it is still displaying the
formula rather than the result.


"Niek Otten" wrote in message
...
The cell was formatted as text before you entered the formula.
Format as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten

"Scudo" wrote in message
. uk...
I have the following in cell A60 It is used to add the amount of entries
in
the column A. It used to give me a total in A60 but for some reason now
gives me the formula. have I done something I shouldnt have?

=COUNTA(A3:A59)