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.