Convert Numbers to Words in Excel

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

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

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

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

Easiest video so far! Thanks a bunch

Thanku

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.

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

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.

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

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

I think you can delete Dollar from the code