Format all to general.

Copy an empty cell.

Select the range of "numbers".

EditPaste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Sat, 6 Mar 2010 15:30:01 -0800, Donna wrote:

I copied and pasted a bank statement from my online bank account into excel.
It keeps the infomation in the correct columns and I can copy and move an
individual column. My trouble is I cannot sum the amount column. I have
tried copying and pasting back as special values but no luck. Any ideas?