The copied data probably contains extra spaces and is formatted as text. To
try and force it to be a number, try this:

Input 1 into a blank cell somewhere, copy cell. Select your data range,
right-click, paste special. multiply. That should force XL to make all the
data numbers, and you can then sum.

--
Best Regards,

Luke M
"Joe" wrote in message
...
I just cut and pasted some numbers from a web pages and they went into
excel just fine but when I try to add them together using the autosum
feature it doesn't work, the sum is always 0. Is there some way I can
format the info to get the cells to recognize the values? I tried to
format the values to just numbers to no avail.