>I use the following:
>
>"$ " + ALLTRIM(TRANSFORM(nTotalDistrCost, "999,999,999.99"))
>
>The above will format with commas for the thousands separator and trim to two decimals:
>
>$ 9,999.99
Awesome that's exactly what I was trying to get!
Thanks a bunch Greg
Thanks
Jon
Non-MVP Non-MCP Non-MCSE
Visual FoxPro, What else is there?