Page 1 of 1

comma separator without decimals

Posted: Fri Apr 04, 2008 5:14 pm
by Rob
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.

Posted: Fri Apr 04, 2008 5:19 pm
by COBS Tech Support
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')