Is it possible that the bank numbers downloaded as text? If you select one
of the cells and look at the value in the fomula window you will see a single
quote infront of the number.

Create a column next to the bank numbers that say "=value(C1)" (assuming the
banks number is in C1) and then copy that down the column. Then you should
be able to sum that.

"HHG" wrote:

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!