Michael's post worked for me. I was able to replicate the issue, and this
resolved it.

"Michael" wrote:

John, after you import your data, put 1 in a separate cell, and copy it.
Then select your data cells and paste special - multiply. This should turn
them into numbers.
--
Sincerely, Michael Colvin


"John Spann" wrote:

An example would be:
cell f3 is 81.61
cell f4 is 81.30
Formula in cell g4 is: =f4-f3
The result is #value!
John


"Bob Phillips" wrote:

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