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

SYSFORMAT seems to have no bearing on it (other than setting the SET DECIMALS to the Windows setting). Only the SET DECIMALS does.