Concatenating Numbers & Text to create a String

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Text String: Formatting Text and Numbers?	=?Utf-8?B?ZGo0Nzk3OTQ=?=	Microsoft Excel Misc	5	30th Jun 2007 12:19 AM
Help - separating numbers from a text string that appear on the right	Faz1	Microsoft Excel Discussion	5	14th Dec 2005 05:33 PM
Concatenating text to numbers	=?Utf-8?B?S2Vu?=	Microsoft Excel Programming	2	8th Nov 2004 06:00 PM
how do i get numbers from a text string	=?Utf-8?B?WmFjayBE?=	Microsoft Excel Misc	3	3rd Nov 2004 11:31 PM
filtering out a string of numbers out of a cell with text and numbers	brucejd	Microsoft Excel Misc	2	6th Aug 2004 12:03 AM