I'm trying to sum a copied table form a web site. I can copy and paste the information but when I try to add it always results in zero. Do you have any advice?
I'm trying to sum a copied table form a web site. I can copy and paste the information but when I try to add it always results in zero. Do you have any advice?
I suspect that the information you are seeing is text rather than "numbers". It is often the case that data imported from web pages.
You can try using Paste Special with an arithemetic operation to coerce the "numbers" into true numbers.
Put a numeric 1 in a "spare" cell. Copy that cell. Then select all the cells you have imported. Select Edit, Paste Special and choose the Multiply operation.
If that does not work, post your workbook for more detailed investigation.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks