View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brock Brock is offline
external usenet poster
 
Posts: 6
Default Formatting Data Pasted from Web Based Table for Summation

I have cut data out of a web based table and pasted into excel. I then try
to sum a column of this data but it will not sum. I checked the text format
and their don't seem to be any issues. Note that I can cut this data from
the web page and paste into word, then copy from word and "paste special"
into excel and then summing works. I'm trying to aviod these intermediate
steps. Your help would be appreciated.