My friend asked me if we have an option in Excel to spell out the numerals. After some Googling I found it is indeed possible!
Here is what you can do:
Note: This is a modified version of the code from Microsoft's KB213360 article to match Indian Currency requirement
Update about Add-In:
After this... many friends from accounting background kept asking me if there can be a simple way of doing this as they frequently use this in invoice, cheque printing, voucher printing and other things... The above procedure has limitations - for every new file created we need to follow all the above steps.
After some research I came to know we could actually create VB Add-Ins for Excel which can be enabled in all versions of Excel. I did exactly that - created an Add-In!
To make things simple:
For MS Excel 2010:
For older versions:
That is it! Now you can use InWords function anytime in any file - existing/new without worries Enjoy!!!