Numbers won't "SUM" from YAHOO

[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

 

[Ken Wright]

See my answer to your first posting

 

[Robin Chapple]

Thanks Ken,

The first message was not delivered to mmy machine by usual dowload. I
had to ask for sample headers to get it.

The job is fixed. Thanks for your help. An interesting URL

"Peace, Health and Happiness in 2004"

Robin

 

[Ken Wright]

My pleasure. There is a lot more really good stuff on the end of that URL as
well.