google.com, pub-7005347536103574, DIRECT, f08c47fec0942fa0
Pranab Logo

Convert Numbers to Words/Text in Excel WITHOUT pasting macros again! – INWORD Excel Addin

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.

Therefore, 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. In other words, 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.

See also  Income tax Arrears Relief Calculator U/s 89(1) From the F.Y.2000-01 to F.Y.2020-2021 With U/s 115BAC in the Budget 2020 With New Tax Regime or Old – What should you pick?

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. However, 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

https://www.cleartaxindia.com
https://www.cleartaxindia.com
https://www.cleartaxindia.com
https://www.cleartaxindia.com

For instance,  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 Above all,

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

Enter your email address:

Delivered by FeedBurner

Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *