In A1 I type ' $2,000.000 with a space after last zero. I use the apostrophe
(') to make sure I had text. I copied a blank cell (Excel will treat this as
zero). Selected the cell with ' $2,000.000 and used Edit | Paste Special
with Add specified. Now the cell show 2000; I can format it to display
$2,000.00.

Note that having copied the blank cell, I could have selected a range to do
the Paste Special
Try this and tell us if it works with your data
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message
...
I have a column of numbers that look like $2.000, $22.000, $222.000 or
$2,222.000. The problem is they have a leading space (before the $)
and lagging space (after the third 0).

I've tried text to columns, =trim, =clean and copy/past special/values
or addition or multiple with no luck!

I just need to convert them text to numbers - HELP! Solutions are much
appreciated.