After formatting, have you tried, from the 'Data' menu, the 'Text to Columns'
option? I've found that formatting number data as 'General' in cases like
this helps.
--
T Tipsy


"John Spann" wrote:

Thank you for your response. This is not the problem. The numbers from html
are not recognized as numbers in excel, even though they look like numbers.
I even formatted them as numbers. But when I try to create a formula, I get
#value!

I did paste special.

Thanks again.
John


"Sean Timmons" wrote:

That's because the format of the cell isn't correct.

Typically, if you

copy a blank column
right-click on the data column
paste special/formats

it will be corrected.

"John Spann" wrote:

I am cutting from Trade station using HTML, and pasting into excel. When I
try to create a formula, I get error #value.
Thanks

John