| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format on Excel File saved from .html file
This worked. Thank you very much.
"Gord Dibben" wrote: Your numbers probably have the invisible non-breaking spaces due to the html. Select all and Format to General then EditReplace What: Hold Alt Key and type 0160 (type the numbers on the numpad) With: leave blank Replace all. If no joy you may need a macro. Post back if that's the case. Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 15:36:14 -0700, joyfulone wrote: I can save files as .xls from a web-based program that I use. When I save the file, I change the type from a .html to a .xls. I can't get the numbers in the new .xls file to be formatted as numbers and so I can't use formulas with them. Does anyone know how to correct the formatting? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file not opening when saved with Extention .html | Excel Worksheet Functions | |||
| How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
| convert excel file to html file | Excel Discussion (Misc queries) | |||
| swf flash file embedded in html file which is edited in excel.. he | Excel Discussion (Misc queries) | |||
| Picture disappears when saved as html file | Excel Discussion (Misc queries) | |||
Threaded Mode
