View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abdul[_2_] Abdul[_2_] is offline
external usenet poster
 
Posts: 137
Default Convert number to arabic(Hindi) format with text

Hi,

How I can convert a number to arabic(Hindi) format using vba


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

I want this with some text for eg.

"This Number is 2000" and 2000 formated as "[$-2000000]#0,000.00"

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

Thanks