You have to edit them as well as re-format them.

What is the formula?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"John Spann" wrote in message
...
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