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

[@guillermosoria506]

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

[@td_kdname5197]

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.

[@shadeed68]

same here - no editing of the formula was needed. The one on office 365 site is flawed

[@raphaeluzor6193]

Excellent tutorial. Saved me hours of work!

[@Dexter7602]

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?

[@wayneedmondson1065]

Awesome! Thanks for sharing the code!!

[@pauldowling233]

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

[@syedmuhammedismaeel2226]

Please check the code I shared in the comments of this video regarding the Indian numbering system

[@IvanCortinas_ES]

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

[@ChesterTugwell]

Thanks Ivan

[@arshadhoosain8468]

Thank you so much! For me, with numbers that are divisible by 100, I get the word "and" at the end of the result. So 500 = "Five Hundred and" or 1,500 = "One Thousand Five Hundred and". Is there any way to fix this?

[@VolkanTuran75]

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

[@gurungkareena9376]

What formula did you delete for no cents?

[@arslanhaider6404]

Great 👍 thanks

[@Poems256]

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

[@sadeepasathsarani708]

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

[@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

[@felipehk73]

Thanks, it worked!

[@lucianoamorim700]

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

[@syedmuhammedismaeel2226]

Please check the code I shared in the comments. It should give you an idea

[@silverawning2095]

thank you

[@mikev637]

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.

[@rizkhan9183]

Save the file as Excel macro - enabled workbook. It is an option when you save an Excel file.

[@hasanarif201327]

Please give the link

[@daddada2984]

this is power

[@khathishnc2745]

Thanks for the video.
Please help to change the currency to Qatar Riyal.

[@ceyhunkvrak7791]

👏