>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?
>
NTOM() converts a numeric to a currency value.
>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