import from web

[Jander]

Hi ,i'm importing from a web page some data into excel .

The problem is that i can't use imported numeric cells for aritmetical
operations and functions . I tried to use /format/cells/number option in
menu bar for changing cells properties but its impossible to do any
numerical operation or function with this cells .

What can i do ?
thanks.

 

[Nick Hodge]

Jander


Put a 1 in an empty cell and copy it. Highlight the data and select
Edit>paste special...>Values+Add. That should do it

 

[Jander]

Nick Hodge escribió:

Jander


Put a 1 in an empty cell and copy it. Highlight the data and select
Edit>paste special...>Values+Add. That should do it

from html data cells with numeric date ,if i do special copy over cells
format it changes it ok but i can't do any math operation.