Concatenating Numbers & Text to create a String
 

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

Concatenating Numbers & Text to create a String
 

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

Concatenating Numbers & Text to create a String
 

Thanks
Dave Peterson wrote:
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]
--
Message posted via http://www.officekb.com


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