Format Number as Arabic (Saudi Arabai) inside text

[Abdul]

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

 

[Tom Ogilvy]

maybe something like

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

 

[Abdul]

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

maybe something like

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

--
Regards,
Tom Ogilvy

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

 

[Tom Ogilvy]

Sub ABC()
Range("A2").NumberFormat = _
"\T\h\i\s\ \n\u\m\b\e\r\ \i\s\ [$-2000000]#0,000.00"
End Sub

worked for me. If you want the text string to be in Saudi/Arabic as well,
then I can't say.

--
Regards,
Tom Ogilvy

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

maybe something like

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

--
Regards,
Tom Ogilvy

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

 

[Abdul]

Thanks

How I can Add a text and number using code?

A1 is empty now.

I want to add "This number is 2000" in A1 thru VBA and the number tobe
formated in Hindi ([$-2000000]#0,000.00")

Thanks

Sub ABC()
Range("A2").NumberFormat = _
"\T\h\i\s\ \n\u\m\b\e\r\ \i\s\ [$-2000000]#0,000.00"
End Sub

worked for me. If you want the text string to be in Saudi/Arabic as well,
then I can't say.

--
Regards,
Tom Ogilvy

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

maybe something like
Range("A2").NumberFormat = """this number is ""$#,##0.0"
columns(1).Autofit
--
Regards,
Tom Ogilvy
:
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

 

[Carl Hartness]

A1 could be a formula ="This number is " & TEXT(A2,yourformat).
An equivalent VBA statement would be
Range("A1") = "This number is " & FORMAT(Range("A2"),yourformat).

Carl

Thanks

How I can Add a text and number using code?

A1 is empty now.

I want to add "This number is 2000" in A1 thru VBA and the number tobe
formated in Hindi ([$-2000000]#0,000.00")

Thanks

Sub ABC()
Range("A2").NumberFormat = _
"\T\h\i\s\ \n\u\m\b\e\r\ \i\s\ [$-2000000]#0,000.00"
End Sub

worked for me. If you want the text string to be in Saudi/Arabic as well,
then I can't say.

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 <[email protected]>
wrote:
maybe something like
Range("A2").NumberFormat = """this number is ""$#,##0.0"
columns(1).Autofit
--
Regards,
Tom Ogilvy
:
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- Hide quoted text -

- Show quoted text -