Hi Ed,

THanks for putting me on the path to solving this. I see that TRANSFORM does great if the value is a currency value. If it is a numeric value how can I change it to currency in the report?

THanks

>>I have the need to display currency left justified and trimmed of blank spaces with two decimals and thousands seperator.
>>
>>If I use the format @B$ by selecting the Currency and the Left Justify option I get the following:
>>$123456.1234
>>
>>If I change it to $999,999.99 I get the following
>>$ 456.66
>>$123,123.55
>>
>>I need
>>
>>$1.55
>>$123.45
>>$123,345.99
>>
>>What am I missing?
>
>
>Try
>* Before runniung report
>SET DECIMALS TO 2
>
>*For output:
>? TRANSFORM(yCurrencyvalue)
>
>>
>>TIA