>I have tried a few options, and just have not found the right set of formatting commands.
>here is what I am trying to do.
>m_value = 789456.1000000
>Display_value should look like $789,456.10
>
>also 123.0000000 should look like $123.00 not $,123.00
>
>so I think I asking for the format code
>
>thanks
>Bob Lee

Bob,
Try the following:

chrtran(transform(789456.1000000,"$999,999,999.00")," ","")
chrtran(transform(123.0000000,"$999,999,999.00")," ","")

HTH.