Hello,

How can I change the format of a variable to currency within a
concatenation?

For example, suppose I have

cells(1,1).value="The total is " & s

but I want s to be formatted as currency.

Thanks.

One way:

Cells(1, 1).Value = "The total is " & Format(s, "£0.00")

In article <(E-Mail Removed)>,
(E-Mail Removed) wrote:

> Hello,
>
> How can I change the format of a variable to currency within a
> concatenation?
>
> For example, suppose I have
>
> cells(1,1).value="The total is " & s
>
> but I want s to be formatted as currency.
>
> Thanks.

cells(1,1).value="The total is " & Format (s,"$0.00")

Or a more comprehensive format code of your choice

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| Hello,
|
| How can I change the format of a variable to currency within a
| concatenation?
|
| For example, suppose I have
|
| cells(1,1).value="The total is " & s
|
| but I want s to be formatted as currency.
|
| Thanks.
|

Hi Quinn,

try

cells(1,1) = "The total is " & format(s, "$#,##0.00")


Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



(E-Mail Removed) wrote:
> Hello,
>
> How can I change the format of a variable to currency within a
> concatenation?
>
> For example, suppose I have
>
> cells(1,1).value="The total is " & s
>
> but I want s to be formatted as currency.
>
> Thanks.
>

p.s.

I think you can also do this:

cells(1,1) = "The total is " & format(s, "currency")

Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



strive4peace wrote:
> Hi Quinn,
>
> try
>
> cells(1,1) = "The total is " & format(s, "$#,##0.00")
>
>
> Warm Regards,
> Crystal
> *
> (: have an awesome day
> *
> MVP Access
> Remote Programming and Training
> strive4peace2006 at yahoo.com
> *
>
>
>
> (E-Mail Removed) wrote:
>> Hello,
>>
>> How can I change the format of a variable to currency within a
>> concatenation?
>>
>> For example, suppose I have
>>
>> cells(1,1).value="The total is " & s
>>
>> but I want s to be formatted as currency.
>>
>> Thanks.
>>