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

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.

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

### Also checkout the following related Excel tutorials:

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

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

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

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

7. Send me numword EXCEL Addin..

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

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

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

11. Mukund Toshniwal

Hi Hasan ji,

can you pls share NUMWORD add in file

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

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

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

15. Please send me NUMWORD fileâ€¦.

16. Assalam O Alikum!

Can i get the add in for excel

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

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

19. Hassan Fazal sb
pls chek

thanks

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

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

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

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

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

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

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

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

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

Regards

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?

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

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

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

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

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

With regards,
P. Moses

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

Thanks

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

39. Mr. Hassan

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

Regard,
Khalid

Thanks

Thanks

44. Nirmal Pankhania

Hassanji,

• Nirmal Pankhania

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

Thanks

46. Nirmal Pankhania

47. Please send me the excel file

48. Hassan ji…

• Sent

Thanks

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

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

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

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

53. Dear Sir,

54. Great Work Keep it up Hassan !

Thanks Again

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

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

58. A great work indeed.

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

60. Thanks a lot for this Add-in.

• can you send me this Adds-in

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