Spell Number In Excel 2013 Without Currency

Go to developer tab.

Spell number in excel 2013 without currency. How to create spellnumber function without currency. Spell out currency numbers to english words in excel. However it is not a formula but a macro function or to be more precise excel user defined function udf.

2 click insert module and paste the following macro in the module window. In this video we are going to convert numbers to words in any cu. I am using excel 2003.

The add in now includes conversion for dinar currency to words which is not shown in above animation. If you need a different currency you can change dollar and cent with the name of your one. Type the formula spellnumber a1 into the cell where you want to display a written number where a1 is the cell containing the number you want to convert.

Under the insert menu click module. Also distributing the files with numword functions implemented is also easy. This formula converts numbers into american currency dollars but you can adjust it to convert into any currency or unit by just finding and replacing dollars and cents.

Any number written in b2 will be converted into words. Copy and paste the below code into the module sheet. I am working in namibia i am dealing with different vendor which are in different currencies like us rands n gbp etc.

This formula applies to b2. Hi yogesh sir i am glad to find your site while looking for spellnumber function in excel. 1 hold down the alt f11 keys and it opens the microsoft visual basic for applications window.