Amount to Words Excel Macro for India - 16 parameter Function |

Опубликовано: 16 Март 2025
на канале: Efficiency 365 by Dr Nitin

556

The most comprehensive macro for converting amount (numbers) to words in Indian currency. Flexible and configurable output. Sixteen parameters!
Change what you call Rupees and Paisa, change case, decide whether to put Only, add commas, define spelling of lakhs and more.
Easy to use and versatile customization dialog to generate the function syntax without typing.
The code is a masterclass in writing VBA macros. By my friend and a tech genius Raj Chaudhuri (https://github.com/rajch)

Download add-in file (zip)
https://efficiency365.com/wp-content/...

Contents 📚
00:00 - Intro
00:28 - Download and Install
01:46 - AmountToWords function
02:56 - Function generator
03:29 - Keyboard Shortcuts
05:45 - Source Code

Blog article
https://efficiency365.com/2017/01/02/...

Github link for javascript version
https://github.com/rajch/numberstowords

Related videos 📺
Apply Excel chart templates - Macro -    • Apply Excel chart templates - Macro |...
GetPivotData macro - Copy from pivot and paste as GetPivotData -    • GetPivotData macro - Copy from pivot ...
Arrange Pictures in one click - PowerPoint Macro - arrange 100s of pictures instantly -    • Arrange Pictures in one click - Power...
Animate PowerPoint Tables - Split individual cells and animate in just two clicks - Macro. -    • Video

For transforming efficiency across your organization
Contact Dr Nitin at [email protected]

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn :   / nitinparanjape
Twitter :   / drnitinp

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)