maybe something like

Range("A2").NumberFormat = """this number is ""$#,##0.0"
columns(1).Autofit

--
Regards,
Tom Ogilvy


"Abdul" wrote:

Hello!

How I can format a number with a text

Range("A2") .NumberFormat = "[$-2000000]#0,000.00"

If I want " this number is 2000" then

something like
Range("A2") ="This number is " & format(2000, "[$-2000000]#0,000.00")

Thanks