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.

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.

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.

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.