Convert Numbers to Words/Text in Excel WITHOUT pasting macros again! – NUMWORD 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 NUMWORD.

Love reading and learning Excel? Subscribe my youtube channel dedicated to Excel.

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.

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.

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

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?


  1. I also have same issue. its working only in that particular excel file in which we have add “ADD-IN” and also if i close and open the same file and change the numbers it will give #Name error and same for anyother file. 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. please e-mail this updated ADD-IN file to my email. I am using Microsoft windows 7 professional and Office 2013 professional. My file having security of cell lock as well.

  2. With NUMWORD Pounds, if the number is £19017.65 it will say: Nineteen Thousand Seventeen Pounds and Ten Pences . Note that Pences is not correct, it should read ‘Pence’, could you possibly change this in the addin? Thanks

  3. Sir Can you make this adds in for Rial Omani; i,e. 125.324 Rial Omani One Hundred Twenty Five and Three Hundred Twenty Four Baizas (Bz) Only

  4. Thank you sir for sharing the numword add in but unfortunately up to now i did not yet received download link in my email address. Please send me the download link. Thank you!

    • Please send me a file for convert numbers into words in Excel.
      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?

  5. Dear Sir,
    I have applied the method, it is efficiently converting numbers into Pak Rupees, but one problem. i have to repeat the same procedures of opening add in each time i open Microsoft excel. how to solve this problem.

  6. asalam alykum
    i need number without decimal numbers
    in round but this addin shows figure with paisa

    One Thousand Eight Hundred Seventy Eight Rupees and Eighteen Paisas
    what i do sir

    • You can wrap the function in CONCATENATE function or simply use & operator with this to get ONLY word annexed at the end.

  7. Greetings!
    First of all, I would thank you to create this function. There is no problem when I give up to 99999. But when I give 100000, I should be say ‘One lakh rupees’. but function said ‘one hundred thousand rupees’. How to change it?
    thank you in advance.

    With regards,
    P. Moses

  8. Dear Sir,
    I would like to request you to please update the add-ins NUMWORDTaka for Bangladeshi Taka & Poysha.
    113051495.45 = Eleven Crore Thirty Lac Fifty One Thousand Four Hundred Ninety Five and Forty Five Poysha Only

    Hope and believe that you will help me in this matter.


  9. Dear Sir.

    good morning you to

    i would like to request you to update the coding of currencies , because EX ( Rials ) there is many country are using same currency , so we need to define the country currency as Ex below :

    Forty Three Thousand Two Hundred Seventy Seven Rials and Fifty Six Baiza Only

    to be came

    Omani Rials Forty Three Thousand Two Hundred Seventy Seven and Baiza Fifty Six Only

    can you please help me in this matter.


  10. sometimes it should say pence but it says ‘pences’, you may have used ‘cents’ and converted that to pence, in english we don’t say pences we say pence. can you correct

  11. Dear Sir,

    Thanks for the Add-In. It works great.

    I am, however, hoping if you could add the Philippine Peso among the currencies in the add-in? Or if you have an Add-In that has no currency?

    Hoping for you kind response to my query.

    Thank you

  12. 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?

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