How to convert numbers into words in Indian Currency Format

abinkar

New Member
Joined
Jul 31, 2013
Messages
11
How to convert numbers into words in Microsoft excel in Indian Currency format.

I wants to convert numbers into the following format.
1) to convert 12,23,12,123.56 into "Rupees Twelve Crores Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three and Fifty Six Paise Only".
3) to convert 1,01,01,123.56 into "Rupees One Crore One Lakh One Thousand One Hundred Twenty Three and Fifty Six Paise Only".
3) to convert 23,12,123.00 into "Rupees Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three Only".

Please help. Thanks in advance.

- Abhinav Binkar
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
abinkar,

There is a lot of information out there if you do a search on the web for:

excel vba convert number to words

excel vba convert number to words Indian Currency
 
Last edited:
Upvote 0
Thanks but i was unable to find the one with below particular conditions.

1) to convert 12,23,12,123.56 into "Rupees Twelve Crores Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three and Fifty Six Paise Only".
3) to convert 1,01,01,123.56 into "Rupees One Crore One Lakh One Thousand One Hundred Twenty Three and Fifty Six Paise Only".
3) to convert 23,12,123.00 into "Rupees Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three Only".

Please help sir.
 
Upvote 0

abinkar,

You are welcome.

but i was unable to find the one with below particular conditions.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.
 
Upvote 0

Forum statistics

Threads
1,213,559
Messages
6,114,302
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top