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)