Gord Dibben wrote...
Probable that the numbers are imported as Text.

And if these numbers come from an HTML table in a web page, more
probable still that they have trailing HTML nonbreaking spaces, which
are a PITA to eliminate.

Format all to General.

Unnecessary.

Copy an empty cell and then select your range of data then EditPaste Special(in
place)AddOKEsc.

Doesn't help when cells contain HTML nonbreaking spaces.

Easiest way to deal with this is to select the range containing the
imported cells and run the menu command Edit Replace ([Ctrl]+H should
work for the fashionable set who've moved on to Excel 2007). The
Replace with field in the Find and Replace dialog should be blank/empty
in order to DELETE the HTML nonbreaking space characters - tab to this
field and press [Delete]. Then tab to the Find what field, press
[Delete], then hold down either [Alt] key and press in sequence the 0,
1, 6 and 0 keys in the numeric keypad and release the [Alt] key. This
should appear to have typed a space into the Find what field. Click on
the Replace All button.