Numeric copied from webpage can't be recognised by Excel
 

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

Numeric copied from webpage can't be recognised by Excel
 

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

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

Numeric copied from webpage can't be recognised by Excel
 

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




"Franz Verga" ¼¶¼g©ó¶l¥ó·s»D
...
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

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

Numeric copied from webpage can't be recognised by Excel
 

Nel post
*Turk* ha scritto:

"Franz Verga" ¼¶¼g©ó¶l¥ó·s»D
...
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

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.


Dear Franz,

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

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.


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