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.

View Contents

**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.:

- Dollars
- Pounds
- Euros
- Rupees
- Dirhams
- 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.

For Example:

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

How convert value (100,000.00) in words please help

How convert value (100,000.00) in Words Please help us

Hassan Fazal sb

after many times subscription i not received add in email

pls chek

thanks

NAVEED AHMAD

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.

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.

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!

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

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.

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

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.

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

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

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!

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?

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.

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

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.

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

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

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

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

Thanks

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

Mr. Hassan

Can you please Send me numword EXCEL Addin..

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

Please Send me numword EXCEL Addin….

Thanks

PLEASE MAIL ME THE ADD IN

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

Please send NUMWORD add-in file

Thanks

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

Hassanji,

Please send NUMWORD add-in file.

Already sent to your email

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 🙂

Please Send me numword EXCEL Addin….

Thanks

Please send me NUMWORD file….

Please send me the excel file

Hassan ji…

Send me numword EXCEL Addin..

Sent

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.

Thank you. Great app. working perfectly. Thanks.

Glad its helping 🙂

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

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

Dear Sir,

Kindly send me the link for downloading the file of Add-in to install.

Great Work Keep it up Hassan !

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

Thanks Again

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?

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

A great work indeed.

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.

Thanks a lot for this Add-in.

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.