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

By
Hasaan Fazal
-

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 a 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 the above animation.

Download Excel NUMWORD Add-in

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 the 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 locations, thus different sets 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 Excel NUMWORD Add-in

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?

87 COMMENTS

  1. A feature request – can you have numword without any currency ?

    Thanks

  2. I just purchased this add in.
    It works for me only if I enable the addin using the developer ribbon.
    Every time I start microsoft 365, I have to enable the addin by choosing the xlam file for it to work.
    What am I doing wrong?

    Thanks

  3. Hi Now this add-in not working on my PC I try 3 times to remove and reinstall Microsoft not allowed me to add In.

  4. araceli ramirez araceli ramirez

    HELLO! I WOULD LIKE TO DOWNLOAD THE NUMWORD FILE, HOW CAN I GET IT?

  6. Thanks for the great function, it really helps especially when I deal with some company in Kuwait, where the decimals are used there

    Can you please share with me the add-in with the update you mentioned in the main post? appreciating your great effort to make this possible.

    Regards,

    mohammed kh

  7. Hi, can i have this numword currency in Ringgit and in Malay language pls. thanks.

  8. Send me numword EXCEL Addin..

  9. Hello Hassan,

    Can you send me the addin. I did not get the email

    • Can you send me the number word ADDIN for Excel. I Did not get the email

  10. Hello,
    Please send me numword file… Not receiving the email.

  12. Hello.
    Hope you and uour family will be safe.

    Can you please share the NumberWord Add In file

  13. Mukund Toshniwal Mukund Toshniwal

    Hi Hasan ji,

    can you pls share NUMWORD add in file

  14. i need your this site pakaccountants.com for guest posting so please tell me price,,

    i am waiting for your positive response..

    waiting and thanks..  

  15. Hi Hassan,

    Thank you for the great function, it really helps especially when I deal with some company in Kuwait, where the decimals are 3, not 2.

    Can you please share with me the add-in with the update you mentioned in the main post? appreciating your great effort to make this possible.

    Regards,
    Bashar G.

  16. How can I get this? Have tried twice. Not in my email or spam folder. Thank You

  17. Please send me NUMWORD file….

  18. Assalam O Alikum!

    Can i get the add in for excel

  19. 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.same problem is with me also. plz help me out

  20. Thanks! This helped me alot. One thing, what if i need to remove the currency, as i just need text as “One Thousand Only”

  23. Hassan Fazal sb
    after many times subscription i not received add in email
    pls chek

    thanks
    NAVEED AHMAD

  24. it works fine , but if i want to write 1 lakh how can i do that.

    its reading for RS: 1,00,000.00 = One Hundred Thousand Rupees
    BUT I Need it to be read as one lakh rupees.

  25. Can you please send me the file as there is no download link above and i’ve subscribed but didnt receive an email.

    • Check your spam folder. It must be there. If not let me know and I will send it out.

  26. 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!

  27. Can you please add SwissFranc currency to this Addin. It will be of great help to me as I have Sheet in Excel in which multiple currencies are used such as USD , EURO & CHF (SwissFranc).
    Kindly incorporate the same in this Addin

  28. How could your work be modified to handle numbers in a way other than currency, such as 0.01 being expressed as one hundredth or 5.784 as five and seven hundred eighty four thousandths? There are several VBA routines available on the web to handle money, but not numbers to words for scientific and other uses.

  29. Abubaker Kakule Abubaker Kakule

    Thank you very much

    How about leaving out the currencies bit and just the number words it can be universal for anyone to use the addin with flexibility

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

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

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

  33. 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!

  34. Dear Sir,
    kindly send me the numword excel add-in file.

    Regards

    • Rezaul Karim (Padma Feed) Rezaul Karim (Padma Feed)

      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?

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

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

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

  37. It’s Working but word “ONLY” is Not included.

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

  38. I Was looking for him a lot, This formula hit is very good working on any Currency,
    i am very happy thank you very much sir, Great job, May Allah bless you.???????

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

  40. Please send me a file for convert numbers into words in Excel.

  41. Please Send me numword EXCEL Add-in for FREE Download Excel NUMWORD Add-in
    Thanks

    • Please send me file or download link forn NUMTOWORD addin in excel

  42. Dear Sir,
    Greetings!
    I would like to request you to please update the add-ins NUMWORDTaka for Bangladeshi Taka & Poysha.
    Example:
    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.

    Regard,
    Pulok

  43. Mr. Hassan
    Can you please Send me numword EXCEL Addin..

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

    Regard,
    Khalid

  45. Please Send me numword EXCEL Addin….
    Thanks

  46. PLEASE MAIL ME THE ADD IN

    • You can download from the link provided above any time of the day 🙂

  47. Please send NUMWORD add-in file

    Thanks

    • You can download the file with the button/link provided in the article.

  48. Nirmal Pankhania Nirmal Pankhania

    Hassanji,
    Please send NUMWORD add-in file.

    • Already sent to your email

      • Nirmal Pankhania Nirmal Pankhania

        Dear Hasanji,
        Sorry, I didn’t got those add-in file.

        Can you please re-send it?

        • You can download from the link in this article any time every time 🙂

  49. Please Send me numword EXCEL Addin….
    Thanks

  50. Nirmal Pankhania Nirmal Pankhania

    Please send me NUMWORD file….

  51. Please send me the excel file

  52. Hassan ji…
    Send me numword EXCEL Addin..

    • Sent

      • please send me this Adds-in for my office,

        Thanks

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

    • Can surely do that in the code. Thanks for the feedback will look into it.

  54. Thank you. Great app. working perfectly. Thanks.

    • Glad its helping 🙂

  55. in ms excel – 2007, its not working can you help in this regard

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

  57. Dear Sir,
    Kindly send me the link for downloading the file of Add-in to install.

  58. Great Work Keep it up Hassan !

  59. Thanks A lot for this Add-in. Its really very helpful. I appreciate your effort.
    Thanks Again

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

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

  62. A great work indeed.

  63. can u make this add ins for indonesia currency??

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

  64. Thanks a lot for this Add-in.

    • can you send me this Adds-in

  65. it’s not working

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

Comments are closed.