Why can't I use SUM when pasting HTML code into new sheet.
 

I have tried using the SUM function from different cells to no avail.

Why can't I use SUM when pasting HTML code into new sheet.
 

Hi

It sounds as though the values may have come across as Text.
In a spare cell on your sheet, enter the number 1. Copy the cell, mark
the range of Data you have copied and Paste SpecialMultiply.
That may well coerce the values to numeric.

Alternatively there may be extraneous spaces, or the non-breaking space
character Char(160) embedded within the data.
Use David McRitchie's TRIMALL() function to clean up the data.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards

Roger Govier


"Crosscatch" wrote in message
...
I have tried using the SUM function from different cells to no avail.