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.
- Open Excel
- Open Developers Mode (Alt+F11)
- Go to “Insert” in Toolbar and Select “Module”
- Copy paste the code into the created module here
- =SpellIndian(number) will deliver the desired objective.