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.

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.

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.
.

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?

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?