View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default Autosum doesn't recognize cell values after I cut and paste values

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