Convert Numbers to Words in Excel

Convert numbers to words seems lot a often sought out request for Excel. One day it may be a function or even command that can be entered or clicked on the ribbon. However it's not, but there is a workaround solution that Microsoft has provided in the form of VBA. They actually posted a knowledge article (along with the code) on a function call SPELLNUMBER. Just do a web search for this text to find the Microsoft page to get the code and instructions on how to apply it. One caveat is that there will be some errors to troubleshoot through, but it wasn't so bad.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

[excelisfun]

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

[debbiedepinet]

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

[pearlandisdeducationfounda]

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

[georgepleasance]

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

[barttitulaerexcelbart]

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...;))

[just_hop]

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

[luciagonzalez]

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.

[javierpena]

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.

[olawalepopoola]

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

[longtll]

I think you can delete Dollar from the code

[jasbirkaur]

Can I add United States Dollars in the front