Carmel, sounds like the cell is formatted as text, format to something else,
general or number... and try it again
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Carmel R" wrote in message
...
Hi Everyone!
In one particular worksheet, when I try to AutoSum a column of numbers,
all
I get is the formula, i.e. "=SUM(A1:A1000)". (If I highlight the column I
can see the sum at the bottom right hand corner).
Can anyone suggest what I might have done wrong???
Thanks in advance for any suggestions,
Carmel