Hi
- select an empty cell and copy this cell
- select your imported numbers
- goto 'Edit - Paste Special' and choose 'Add'

--
Regards
Frank Kabel
Frankfurt, Germany

"Jacob" schrieb im Newsbeitrag
...
Hello guys, I have one frustrating problem. I copied a table from
Amsouth
Bank and pasted it into Excel. I then wanted to do some calculations.
No
matter how i formatted the cell whether Number or Currency the number
always
appeared on the left hand side and would not calculate. Number are
supposed
to be aligned right. Any suggestions. This is frustrating!

Thanks!