Problem with money/number formatting

[gshockxcc]

I have US currency formatted as '1,280.00 USD' in my data report.  I have used 'PurgeChar' to remove the ' USD' from the field.  But no matter what I do to format the values as numbers/money, I can't seem to get the correct output.

I have attached a sample file.

[gshockxcc]

Now, I am intrigued.  How did you find this?  I found the chr(160) in my ASCII table after reading your post, "non-breaking space."

I aliased the field again and it works perfectly, same as 'dathu.qv's' suggestion.

Thanks for the tip!