Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » Currency Format with comma in Method Report Designer

Currency Format with comma in Method Report Designer

Last post 06-01-2011 2:08 PM by Method_Michael. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 06-01-2011 1:36 PM

    • Geekoid
    • Top 25 Contributor
    • Joined on 06-02-2010
    • Phoenix, AZ
    • Posts 420

    Currency Format with comma in Method Report Designer

    Reply Contact

    Hello,

    How can I create a format to show the commas for numbers greater than 100? For example, I want $1000.00 to look like $1,000.00. I tried to create a format $0,000.00 but it shows it as $0,100.00, etc. and I don't want the leading zero. And I need the $ symbol in front.

    Thanks!

    Brett
    Go Get Geek!

  • 06-01-2011 2:08 PM In reply to

    Re: Currency Format with comma in Method Report Designer

    Answer
    Reply Contact

    Hi Brett,

    Try {0:C2} as the format string. This is a specfic formatting for currency.

    -Michael

    Michael Melo
    Product Manager
    Method Integration Inc.
    Website: http://www.method.me
    LinkedIn: http://www.linkedin.com/in/MichaelMelo
Page 1 of 1 (2 items)