import from web

  • Thread starter Thread starter Jander
  • Start date Start date
J

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.
 
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
 
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
Click to expand...
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.
 
Back
Top