| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert HTML to number
I have found a table on the web that I would like to use in Excel. If I copy
and paste it into Excel as HTML, it fits into the celss just fine, but I can't do any calculations on it. If I paste it as text (Unicode or not), it all squishes into column A. How can I change the format of the cells so that calculations can be performed? Doing the usual Cell Format stuff doesn't work. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Excel should have a formula to convert number into words | Excel Worksheet Functions | |||
| How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? | Excel Discussion (Misc queries) | |||
| Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Threaded Mode
