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.
Have a glance yourself what I am talking about:
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
No comments:
Post a Comment