This has been long overdue and I am happy that an Excel add-in that helps convert numbers to words or text is finally here. Just install this add-in and you can easily convert numbers to words in several popular currencies using relevant type of function INWORD.
Unlike a painful process of pasting macros to do this job every time you open a new Excel workbook, once this add-in is installed on the computer user will never have to worry about the tedious coding job.
Have a glance yourself what I am talking about:
UPDATE: The add-in now includes conversion for Indian Currency to words which is not shown in above animation.
Also, distributing the files with INWORD functions implemented is also easy. Simply sent the add-in (or also called plugin) file with the Excel file and ask the receiver to install the add-in. See the steps to install add-in mentioned later in this post.
INWORD in action!
It is really easy to use. Simply have the number in cell and use the INWORD function that corresponds to your currency and it will automatically convert amounts to words in Indian currency.
Using INWORD with other Excel functions
You can easily use INWORD with other Excel functions that process text strings.
For example, if user inputs any number less than 1 whole number but greater than 0 i.e. decimal numbers then INWORD functions process as:
Now some might like/require the appending part and some don’t. I left it to accommodate both as the one desiring just the cents part can wrap INWORD functions inside function as following to get rid of appending dollar part of the string:
Installing Excel INWORD Add-in
Its simple! Once you have the add-in file go to developer tab > Add-ins group > Click Excel Add-ins. A new window will pop up. Click “Browse…” button and navigate to the location where you downloaded/stored the add-in file. Click OK.
Make sure the add-in is checked and click OK again. Excel will load the add-in and now you are good to crunch numbers in words!
Hope this will bring easy to many.
Remember:if you are sending the Excel file in which INWORD functions are used to someone else, don’t forget to send the add-in as well with it.
For Download Inword ExTools you should first Subscribed Through Mail with your Name and your mail Id, and Activate the Mail Alert in your Mail Box, After Activate mail alert, you will get the Download Link to your inbox instantly.
Subscribed Now for Get this Unique Excel Tools
0 Comments