Numbers won't "SUM" from YAHOO

R

Robin Chapple

I have copied the chart of monthly messsage total from YAHOO groups in
order to make a chart.

On YAHOO they are hyperlinks to the messages of that month and appear
and behave in EXCEL as hyperlinks.

I have vopied the hyperlinks to my NOTETAB text editor which leaves me
with text only, tab separated. The cells are formatted as numbers.

I have pasted the result into a sheet and the totals appear as text. I
cannot sum the rows or columns. The result is zero.

In one case I inadvertantly included the row heading "year date" and
that was in the result. So there is still some formatting in the cells
which I cannot see and is preventing the sum function.

What have I missed.

Thanks,

Robin Chapple
 
K

Ken Wright

Run Dave McRitchies Trimall Macro to get rod of any garbage characters still in
your data.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Then copy an empty cell, select all your data and do Edit / Paste Special / Add

After you have what you want, consider using Data / Import External Data / New
Web Query to get data from the web. (Assumes you have 2002 or 2003)
 
Top