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?