Currency Format within a Concatenation

[quinnculver]

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.

 

[JE McGimpsey]

One way:

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

 

[Niek Otten]

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


| 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.
|

 

[strive4peace]

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
*

 

[strive4peace]

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
*