One way:

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

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