Numeric copied from webpage can't be recognised by Excel

  • Thread starter Thread starter Turk
  • Start date Start date
T

Turk

Dear all,

I try to copy some figures from an internet homepage,
but when I copy them into my worksheet for calculation, Excel does not
recognise them as numeric and #Value error message appears in the formula
cell.

Please help

Turk
 
Nel post *Turk* ha scritto:
Dear all,

I try to copy some figures from an internet homepage,
but when I copy them into my worksheet for calculation, Excel does not
recognise them as numeric and #Value error message appears in the
formula cell.

Please help

Turk
Click to expand...

Maybe (quite sure...) it depends on leading or ending spaces that make your
number as text, so Excel can't calculate them. Before to use them in
calculation you can try a trick:
type 1 in a blank cell, copy this cell, select the cells containing the
numbers you pasted from Internet, Edit, Past Special, Operation: Multiply.
Click Ok. Now the numbers should calculate.

Moreover, the best way to import data from Internet, avoiding any such a
problem, is by a Web Query: menu Data, Import External Data, New Web Query;
input the URL of the page you want to import from, then select the table you
want to import, clicking on the small yellow square with an arrow inside
(when you clik on it, it becomes green with a V inside), the you can click
directly Import, or, before clicking Import, you can save your query for
future needs.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Dear Franz,

Hi Italian..... do you think Italy may win the 2006 world cup?

What you say : "type 1 in a blank cell, copy this cell, select the cells
containing the
numbers you pasted from Internet, Edit, Past Special, Operation: Multiply.
Click Ok. Now the numbers should calculate." doesn't work, any other hints
please.

Actually I have checked but found there didn't have any space before or
after the numeric.




Turk
 
Nel post *Turk* ha scritto:
Dear Franz,

Hi Italian..... do you think Italy may win the 2006 world cup?
Click to expand...

I hope so...
What you say : "type 1 in a blank cell, copy this cell, select the
cells containing the
numbers you pasted from Internet, Edit, Past Special, Operation:
Multiply. Click Ok. Now the numbers should calculate." doesn't work,
any other hints please.

Actually I have checked but found there didn't have any space before
or after the numeric.
Click to expand...

Try the other way. Try to import the data you need by a Web Query, as I wote
on my last post.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Back
Top