Did you try this one?

Format all to General.

Copy an empty cell.

Select the range of "numbers" and EditPaste SpecialAddOKEsc.

If no joy could be you have some HTML non-breaking spaces.

Select all cells and EditReplace

What: Alt + 0160 (using numpad)

With: nothing

Replace All


Gord Dibben MS Excel MVP

On Sat, 6 Mar 2010 06:19:16 -0800 (PST), Joe wrote:

On Mar 5, 2:27*pm, ????? (????) ????? <micky-a*at*tapuz.co.il wrote:
Select the range of "numbers" click on 'Data' 'Text to Columns' 'Finish'
Try to Sum, them, now.
Micky

"Joe" wrote:
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.
.

I've tried every solution listed here and still the sum = 0. Is this a
lost cause?