Convert Numbers to Words in Excel

[@stacykim1499]

Easiest video so far! Thanks a bunch

[@DougHExcel]

You’re welcome!!

[@georgepleasance3324]

Very helpful video, also found if you do Ctrl F and do replace inside the module, you can change "Dollar" to "Pounds", "Cent" to "Pence" and add commas after million and thousand, will then do it automatically in the formula

[@DougHExcel]

Hi George Pleasance, thanks for the comment!

[@pearlandisdeducationfounda8202]

You got yourself a thumbs up! Thank YOU!!!!

[@DougHExcel]

Hi Pearland ISD Education Foundation, you're welcome! Thanks for the 👍!

[@just_hop8310]

i want it with decimal like "12/100" does any know pls help me

[@mayda1769]

I love this tutorial. Thanks.

[@DougHExcel]

You are so welcome!

[@debbiedepinet4242]

Thank you SO much! Just what I was looking for!!

[@DougHExcel]

Glad I could help!

[@excelisfun]

Killer Thumb Nail : ) SpellNumber is pretty good too : )

[@DougHExcel]

Thanks Mike!

[@barttitulaerexcelbart9400]

Thanks Dough, nice VBA code. I once did this with just formula's. Long IF and VLOOKUP functions....;) For example when you write a cheque (long time ago...;))

[@DougHExcel]

Hi Bart Titulaer, thanks for the comment! I was looking to see how this could've been done without the combinations of different functions and found the MSFT provided VBA, tried it and was like....wow! Thanks MSFT. Yes I too remember the slowly fading check writing days.....

[@javierpena3308]

Thanks. I found this some time ago, but didn't know how to use it, cause I'm not a VBA user also. Now. Do you know if there is this formula in spanish also. I can't find it.

[@DougHExcel]

Hi Javier Peña, thanks for the comment. I don't know if there is one that has Spanish terms for the output.

[@luciagonzalez192]

Hello Doug, thank you for this video, really helpful! Do you know if there is a function in excel that will turn numbers into words but when the imput has letters included (example: SFS538FS - would like to read "S F S five hundred thirty eight F S")? .. Spellnumber does not recognize when there are letters in the cell.

[@DougHExcel]

Oh wow. A kluge would be to separate the desired character into separate columns and use the code but that’s a lot to do. Sounds like something for a more advance VBA setup🤔

[@olawalepopoola6941]

I was able to edit the Number to Text formula to accept my country's currency without using a manual method.

[@jasbirkaur4047]

Can I add United States Dollars in the front

[@DougHExcel]

Combine the text with concat or …. See if this helps Join Cell Values with CONCATENATE, CONCAT or TEXTJOIN Functions kzbin.info/www/bejne/anikm4Sqgsx6qbM

[@longtll]

I think you can delete Dollar from the code

[@DougHExcel]

It probably can be deleted in the code, maybe if I get better in VBA I'll do it, but I'm sure some VBA pro will add to the thread!

[@aeunsekar]

Thanku

[@DougHExcel]

You’re welcome!