| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format on Excel File saved from .html file
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number Format on Excel File saved from .html file
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number Format on Excel File saved from .html file
A possible solution, enter 1 into an empty cell, right click it and 'Copy'.
Select all the numbers you've saved, right click, 'Paste Special', check 'Multiply' OK. If that doesn't work, look at the numbers in the formula bar and see if they contain leading or trailing spaces. You can get some very odd things transferring data from web sites as I've found out myself! Regards, Alan. "joyfulone" wrote in message ... 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. |
|
#4
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. |
| Reply |
| 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) | |||
Linear Mode
