Convert Numbers to Text (NPR)
This VBA Code will create a simple function named "SpellNumber" that will basically convert the number into Text. We can get a lot of codes for conversion in English Currencies but this will convert in Nepali Currency Unit (i.e. Crore, Lakh etc.)
1. Open an Excel Sheet.
2. Now open the VBA Code window by pressing Alt + F11
3. In the VBA Tab click Insert Menu and Insert "Module".
4. Double Click the inserted Module and inside it paste the VBA Code provided below.
5. Now go back to excel sheet and you can use the function "SpellNumber"
6. So type =SpellNumber(select cell with number) and enter.