Can Not get cell to accept any format change! Source from html

[Quentin]

Copied bank html statement to Excel Worksheet. Columns of numbers &/or cell
will not accept a format change to Currency. Same columns would not add.
Did 'Paste Special' every option... no change occured.
Did save as to csv and csv file responded the same.

 

[Dave Peterson]

Lots of times, when you copy|paste from a web site, you'll get those HTML
non-breaking spaces (char(160)).

You can clean them up with formulas, but if you have to do it lots of times (or
with lots of data), you may want to use a macro.

David McRitchie has a macro that can help clean this:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)