| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IMPORTING from Scottrade GAINSKEEPER table?
How can I import data (numbers) from HTML-tables and reformat the numbers so
that they can be added, multiplied etc. The standard method of PASTE SPECIAL does not work. Copying the table and importing it into WORD and EXCEL is easy; thereafter the manipulation only yields "0" (zero) and #VALUE!. Apparently the numbers are imported with formatting attached by the HTML table. Can these numbers be converted to text, general or EXCEL 2003 numbers? ed in amsterdam; plant tulips, eat herring, enjoy a DUTCH moment! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| importing time from pdf as table and calculating | Excel Discussion (Misc queries) | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Look up/math text | Excel Worksheet Functions | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Threaded Mode
