It might be one of those HTML non-breaking space characters.

David McRitchie has a macro that cleans up this kind of stuff:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

MMangen wrote:

We are copying and pasting a document from the internet and when the dollar
amounts are being pasted into Excel there is a dollar sign in front of the
number, which is not allowing us to use the sub-total function in Excel.
We've tried to re-format, to no avail. I've also used hunt and replace to
take out the dollar sign, still, same result.

--

Dave Peterson