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

"Fredriksson via OfficeKB.com" wrote:

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

--
Message posted via http://www.officekb.com

--

Dave Peterson