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.


  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.
Leave a reply

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