|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 13th, 2003, 03:06 PM
|
|||
|
|||
import from web
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. 
|
|
#2
October 13th, 2003, 07:19 PM
|
|||
|
|||
|
import from web
Jander
Put a 1 in an empty cell and copy it. Highlight the data and select Editpaste special...Values+Add. That should do it -- HTH Nick Hodge Southampton, England "Jander" wrote in message ... 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.
|
|
#3
October 14th, 2003, 12:06 PM
|
|||
|
|||
|
import from web
Nick Hodge escribió:
Jander Put a 1 in an empty cell and copy it. Highlight the data and select Editpaste 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
