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
*



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.