Hey gang

I have a spreadsheet in Excel 2003 that has values imported from a Crystal
report. All the numbers have a trailing space, so I can not format them to
show dollar signs, decimals, comma seperators, etc...

I have tried to use the TRIM function, then copy/pasteValues only, but the
values only paste gives me back the trailing space.

Any ideas?