View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Convert number to arabic(Hindi) format with text

See answer to latest posting of this question.

--
Regards,
Tom Ogilvy


"Abdul" wrote:

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