Convert amount in words (Nepalese currency format: lakhs, crore)

While preparing Bill of Quantities (BOQ), word format is generally preferred. It is a nuisance in excel for more than 500 items. Thus, below VBA code will be a great help.

Steps:

1. Open Excel
2. Open Developers Mode (Alt+F11)
3. Go to “Insert” in Toolbar and Select “Module”
4. Copy paste the code into the created module here
5. =SpellIndian(number) will deliver the desired objective.