Don't just jump in blindly. Take advantage of the built-in guides and tutorials to master the tools available.
Place your numeric amount in cell . In cell B1 , enter =INR(A1) to show the amount in Indian comma format. In cell C1 , enter =RSWORDS(A1) to get the legal line. Your invoice now has both the formatted currency and the spelled‑out amount, exactly as required by Indian law.
: Save the SureshAddin.xla file to a known location on your computer. Open Excel Options : Go to File > Options > Add-ins .
| Method | Strengths | Weaknesses | | -------------------------- | ------------------------------------------------------------------------- | -------------------------------------------------------------------------- | | | Free, offline, respects lakhs/crores, includes reversible function. | Requires initial download; no longer maintained publicly (but still works). | | VBA macro (custom code) | Full control, no external files. | Requires coding knowledge; each user must enable macros; easy to break. | | Online converters | No installation needed. | Slow, requires internet, privacy risk for sensitive financial data. | | Commercial add‑ins | Often come with support and updates. | Cost money; may add bloat; many do not handle lakhs/crores correctly. | | Excel formulas (no VBA) | No macro security warnings. | Extremely complex formulas; limited to 32‑bit integers; break easily. |
This automation saves countless hours of manual typing and eliminates spelling errors that occur when writing large sums manually. It is specifically tailored to handle the Indian "Crores" and "Lakhs" units, which many Western add-ins fail to recognize.
To get the most out of this tool, you must correctly register it within your Excel environment:
