Concatenating Numbers & Text to create a String

[Fredriksson via OfficeKB.com]

I have Totals in a variable that I would like to print out in a string
formatted

Dim Total
Dim String

String = 'The total is " & Total

The result is The total is 9999.9

I want it to look like The total is $9,999.99

How do I format a varible when I am concatinating the Varible to a String.

Thanks
Dana

 

[Dave Peterson]

String = "The total is " & format(total, "$#,##0.00")

 

[Fredriksson via OfficeKB.com]

Thanks

String = "The total is " & format(total, "$#,##0.00")

I have Totals in a variable that I would like to print out in a string
formatted

[quoted text clipped - 15 lines]