Try this formula in a help column


=--TRIM(SUBSTITUTE(A1,CHAR(160)," "))


copy and paste special as values and then use number formatting




Regards,

Peo Sjoblom



"hagen" wrote:

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?