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.