 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / October 2003import 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. 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  SignatureHTH Nick Hodge Southampton, England nick_hodge@btinternet.com > Hi ,i'm importing from a web page some data into excel . > [quoted text clipped - 5 lines] > What can i do ? > thanks. 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.