>>>Also note that if you don't put the space between the Z and the $, then you'll get your format with the $ right up against your number instead of to the left edge of the field.
>>>
>>

>>>price = 50
>>>?TRANSFORM(price,"@Z $999,999,999")  -- "$         50"
>>>
>>>?TRANSFORM(price,"@Z$999,999,999")  -- "         $50"
>>

>>This doesn't work for me :( Without space it doesn't show $ and ,. I want price left justify, e.g. without spaces between $ and number, do I need to strtran(transform(...)," ","")?
>
>No, what I posted gives the results I posted except as noted below. Strange...
>
>One additional thing I notice: I get a ".00" at the end of the $50, (whatever the SET DECIMALS setting is).

Not to jump in here, I was just a little late with my earlier answer.

Check your SYSFORMAT setting. Set it off and decimals to 0 and you will not get the ".00" and the end.

REM