Format("$#####0.00) FIGURED OUT

[twisted]

Originally posted by Pirate
Add the two numbers in an integer or decimal type depends on the number format you'll get . Then use the ToString like shown before .

You lost me! I did however add the ("c") behind my AverageSales and it worked fine, just won't work with my TotalSales:

If SP = 0 Then
            grpAverageSales.Text = (SA).ToString("c")
        Else
            grpAverageSales.Text = ((SA + TS) / (SP + 1)).ToString("c")
 
        End If