Hi Ed,

Thank You, Thank You, Thank You!!!!

I looked at NTOM earlier today and TRANSFORM but didn't put them together....



Thanks for the Help!!!


>>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