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