>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao