Convert Numbers into Words in Microsoft Excel - With or Without Currency | VBA Included in Download

In this Microsoft Excel video tutorial I explain how to convert numbers into their words equivalent. You can do this using a VBA custom function.

I found this version of the function, although very good, had some spacing and wording issues; it also only catered for a dollars version of the number in words.

In my version of the function I have included an additional argument which allows you to specify which currency you want to output the number in words as. I have included dollars and cents, pounds and pence and euros and cents. You can, however, add you own currency options to the function.

My version of the function also allows you to return a version of the number in words without currency being applied.

Table of Contents:

00:00 - Introduction
01:00 - Copy and paste the code into the Visual Basic Editor
02:14 - Setting up custom currency outputs
04:07 - Using the SpellNumber function
------------------------

[td_kdname]

I've been trying to write out checks using Excel but using your tutorial was the first one I was able to get it to work. Thanks for the clear and easy to use instructions.

[raphaeluzor]

Excellent tutorial. Saved me hours of work!

[pauldowling]

Thanks a million, really excellent. For me, with numbers that are divisible by 100, I get the word "and" at the end of the result. E.g. 500 = "Five Hundred and" or 1, 500 = "One Thousand Five Hundred and". Any tips to fix? Thanks. Paul

[guillermosoria]

Great!!! Thank you for sharing this code. It worked perfect👍

[Dexter]

Thanx for an excellent code. It helps a lot. I would like to know how to change the code to output decimals as singles, e.g. zero comma five five?

[VolkanTuran]

For me there is no need to specify like "No Cents", "No Pence" things. I removed from codes. Thanks Chester, great job.

[Poems]

I've copied the code but when i run it i get an "ambiguous name detected" error message. How can i go about it? Thanks

[kleinboertjie]

I encounter a problem, when I enter 1 in the cell and use the formula, it display a blank cell, if I select a currency it display 1 dollar. But awesome formula

[sadeepasathsarani]

Hi, My contry sri lanka,
In English language
20= twenty
21= twenty one
22= twenty two,
But in Sinhala language
20-"විස්ස"
21-"විසි"එක
22-"විසි"දෙක
Words other than 20 are different, how to correct it and write the vba code, thanks

[wayneedmondson]

Awesome! Thanks for sharing the code!!

[lucianoamorim]

Excellent!!
I'm having a problem with the hundred "and dollars", can someone helpe me?

[IvanCortinas_ES]

Thank you Chester. That's a great job!!!

[mikev]

I am completely baffled. It works for me when I set it up in VBA ad use it right off the bat. However, when I close the worksheet and Excel and then reopen it, the "=spellnumber" formula does not come up??? I set it back up and it works until I close Excel down. I am using Excel 365.

[khathishnc]

Thanks for the video.

Please help to change the currency to Qatar Riyal.