ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Convert number to arabic(Hindi) format with text (https://www.excelbanter.com/excel-programming/385137-convert-number-arabic-hindi-format-text.html)

Abdul[_2_]

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



All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com