Hi,
Copy the contents of the page, not sheet copy but select
all cells will do and paste into a new sheet. The sheet
you are using maybe a text sheet or web page that looks
like an excel sheet. better to open a new workbook and
paste the clipboard contents into that one then try the
sum.

also,
If you highlight the column of numbers, your status bar at
the bottom right (in the grey part) will show the sum
value.
- Mark

See my stuff at:

http://www.geocities.com/excelmarksway



Joke of the day:
Q: What's the difference between mens toilet and womens
toilet?

A: Mens toilet seat is always wet!!

HA! ha! Ha!


-----Original Message-----
I have tried everything! I have a column of numbers that
I need to add
together, and I cannot get it to work. All I get in a
big fat 0! I down
loaded the information from my bank. I have tried
reformatting the cells,
but nothing seems to help. If I type in the numbers in
the next column, and
use the sum function, it works...but I do not want to
type in over 3000
numbers! I have even tried copying and pasting the
column to another
column...I am stumped...can anyone help - PLEASE!
.