comma separator without decimals
  • Rob

    comma separator without decimals

    by Rob » Fri Apr 04, 2008 5:14 pm

    Is there a way of using 000,000 separator in VB and forcing VB not to display decimal places. I have a number of reports I would like to display only in whole dollars for subtotals and use the 000,000 separator but if I change subtotals to no decimal places eg str(GrpVar9, 10,0) and have the 000,000 Separator ticked all subtotals are displayed as 0.00 for example i want 55,425 but I get 55,,425.00.
  • COBS Tech Support
    Posts: 678
    Joined: Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Fri Apr 04, 2008 5:19 pm

    You need to untick 000,000 Separator
    Enter a code in the code field
    Click on Formula tab
    Type in the Editor:

    Transform(x, "999,999,999")

    Where 'x' is a field or dictionary value, i.e., Stock->A, or Dictionary('Balance')

Who is online

Users browsing this forum: No registered users and 1 guest