how do I Copy data from a webpage into an Excel 2003 spreadsheet

M

Marinus Mellaart

I have done this "cut and paste" from my online banking website numerous
times in Excel 2000 without a hitch, However, when I try in 2003 the data is
there but when I try to perform a a simple SUM(D1:D15) I get a zero value. I
have tried reformatting the cells to accounting, and numeric, as well as
general but nothing seems to work.
 
F

Frank Kabel

Hi
try the following:
- copy an empty cell
- select your imported values
- goto 'Edit - Paste Special' and choose 'Add'

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag
news:D[email protected]...
 
Top