View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom
 
Posts: n/a
Default Excel formatting

you might have to make a new column and use the value() function to turn
them into numbers

"Cyndi" wrote:

I copied a table from a web page and pasted it into an Excel spreadsheet.
When I try to @SUM the column numbers, I'm unable to do this. Excel returns
a result of zero. Why is this? I've tried to reformat the numbers but that
doesn't seem to help.