Thanks tTom,

It wont work
when I say

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

Then the number I input in A2 will be changing to Hindi (Arabic(Saudi
Arabia)) format

I want add some text to A2 using code with a number and the number
should be in Hindi(Arabic-saudi arabia) format

Thanks


On Mar 13, 3:25 pm, Tom Ogilvy
wrote:
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