Convert number to arabic(Hindi) format with text

Abdul

Guest

Posts: n/a

13th Mar 2007

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

« Count the number of users accessing a shared excel workbook | getting worksheetnames from subfolders »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how change number from hindi to arabic	Abdulrahman	Microsoft Word Document Management	0	18th Jan 2008 12:56 PM
Convert number to arabic(Hindi) format with text	Abdul	Microsoft Excel Programming	1	13th Mar 2007 12:30 PM
Convert arabic number to english text	=?Utf-8?B?VFNL?=	Microsoft Excel Misc	2	9th Jul 2005 10:24 AM
How do I change Hindi number to Arabic numbers in a Word document.	=?Utf-8?B?TWljaGFlbCBNY0NhaW4=?=	Microsoft Word Document Management	2	16th Mar 2005 06:23 AM
convert arabic number to english text format?	=?Utf-8?B?aWNl?=	Microsoft Word Document Management	1	22nd Feb 2005 07:15 PM