Excel Formula to convert Numbers to words in Rupees: No Macro No Coding



Namaskar!

In this Video we will learn a formula in MS Excel to convert numbers or digits into words in Rupees. By Default Excel does not include this function in its functions library but by using VB Script and Macro enabled worksheet you can enable this function in excel.
You can do this by applying SpellNumber Function in MS Excel
Using Macro enabled worksheet is a temporary solution because you have to copy and paste the code in VB script and save your file as a macro enabled…

3 thoughts on “Excel Formula to convert Numbers to words in Rupees: No Macro No Coding

  1. Thanks for this tutorial. I have a small doubt, what if I want the output as 1234 rupees and 25 paise in this format. The output which I am getting now is rupees 1234 paise 25. . For example one thousand two hundred thirty four rupees and 25 paise only. Please help me… thanks in advance.

Leave a Reply

Your email address will not be published. Required fields are marked *