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

13
7678

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 NUMWORD.

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 Dinar currency to words which is not shown in above animation.

Also, distributing the files with NUMWORD 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.

Download NUMWORD Excel Add-in
You can download the NUMWORD Excel ADD-IN free of cost but if you like the effort and gained something valuable then you can set the price whatever you deem fit and pay. If you want to download it for free then simply set the price to “0”. Enjoy!
Download Now

Excel NUMWORD Add-in & NUMWORD Functions

Users that require such functionality are usually accountants working with currency amounts and are from different geographical location, thus different set of currencies. Keeping this in mind I have provided functions to convert numbers to words in not just one currency but SIX of the more popular ones i.e.:

  1. Dollars
  2. Pounds
  3. Euros
  4. Rupees
  5. Dirhams
  6. Riyals

I will surely work to include even more currencies as the need arises with better implementation.

NUMWORD in action!

It is really easy to use. Simply have the number in cell and use the NUMWORD function that corresponds to your currency and it will automatically convert amounts to words in desired currency.

Here is one example where I converted numbers to different currencies using relevant UDF functions:

Using NUMWORD with other Excel functions

You can easily use NUMWORD 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 NUMWORD functions process as:

“Zero [currency] and <number> [currency]”

Like for 0.07 in dollars the result is “Zero Dollars and Seven Cents”.

Now some might like/require the appending “Zero Dollars and..” part and some don’t. I left it to accommodate both as the one desiring just the cents part can wrap NUMWORD functions inside SUBSTITUTE function as following to get rid of appending dollar part of the string:

Did you catch the 1.28 part? Yes! One don’t have to exclude SUBSTITUTE wrapping to show Dollars part if number is greater than 1 dollar.

Installing Excel NUMWORD 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!

However to access developer tab you have to enable it first by customizing ribbon. Following illustration shows all the steps:

Hope this will bring easy to many.

Remember: if you are sending the Excel file in which NUMWORD functions are used to someone else, don’t forget to send the add-in as well with it.

UPDATE: NUMWORD Ver 2
The version 2 of NUMWORD add-in now includes conversion for Dinar currency to words which is not shown in the above animation. And can process up to three decimal places.

For Example:
1210.376 KD will be: One Thousand Two Hundred Ten Dinars and Three Hundred Seventy Six Fils

Download NUMWORD Excel Add-in
You can download the NUMWORD Excel ADD-IN free of cost but if you like the effort and gained something valuable then you can set the price whatever you deem fit and pay. If you want to download it for free then simply set the price to “0”. Enjoy!
Download Now

Also checkout the following related Excel tutorials:

  1. Determine number of currency bills or notes for any amount – Currency bill Calculator [How To]
  2. Creating Currency Converter in Excel [How To]
  3. How to change currency format in Excel? How to have Pakistani Rupees (Rs) currency sign in excel?

13 COMMENTS

  1. its working only in that particular excel file in which we have add “ADD-IN” .but when we exit from that file now open another excel file it does not show that “NUMWORDRUPEE” formula. we have to add this ADD-IN again and again in every file in which we want to convert. Is there any trick to solve this problem. One more thing, after thousands it shows in hundred again, not showing in crores and so on… please solve this. If rectified then please e-mail this updated ADD-IN file to my email – jitendrajora2atgmaildotcom

    • Add-in works at application level and once installed shouldn’t require installation everytime new workbook is opened. Which version of Excel are you using? I will try to check this add-in for that version by reproducing the problem if its there.

      The add-in at the moment supports millions billions numbering system. For lac and crores I might have to make a separate add-in. Will let you know once that is ready.

      • Thanks for support. I’m using Microsoft office home and student 2013 version of excel.
        Actually “Num to word add-in” in available in every new sheet but the formula “NUMWORDRUPEE” got disappear when new excel sheet is opened. Should i do any other additional setting in excel?? or something is wrong with this ADD-IN ??
        And waiting for new ADD-IN which can work in lac and crores also.
        Thanks in advance.

        • Thanks for replying. I currently have the professional version installed and it is working fine. I checked on two other PCs and its all fine as I tried to open close and also in different worksheets multiple times.

          I will try to find a PC with student version installed and check if it is version specific problem. Can you also check the same with another PC and better yet another version of office?

  2. May i ask you what is the formula for the grand total you have where your typing in the numbers? Because whenever i type in the formula and press enter i am getting the word value

    • Just simple numbers no formula to calculate grand total. Can you add more details so that I can understand where and why this problem is arising? Thanks

    • As per my understanding Indonesian currency is Rupiah which is like Rupee currency without paisas. So you can use the formula NUWORDRUPEE.

      Hope this helps.

    • It is working perfectly fine. The above animations you see are taken by having this add-in installed and active. Let me know if you need help in troubleshooting the issue you are facing.

      Thanks.

LEAVE A REPLY