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
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...;))
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.....
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.
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.
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🤔
Combine the text with concat or …. See if this helps Join Cell Values with CONCATENATE, CONCAT or TEXTJOIN Functions ruclips.net/video/4GAjQtMgGsQ/видео.html
Easiest video so far! Thanks a bunch
You’re welcome!!
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
Hi George Pleasance, thanks for the comment!
Thank you SO much! Just what I was looking for!!
Glad I could help!
You got yourself a thumbs up! Thank YOU!!!!
Hi Pearland ISD Education Foundation, you're welcome! Thanks for the 👍!
I love this tutorial. Thanks.
You are so welcome!
Killer Thumb Nail : ) SpellNumber is pretty good too : )
Thanks Mike!
i want it with decimal like "12/100" does any know pls help me
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...;))
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.....
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.
Hi Javier Peña, thanks for the comment. I don't know if there is one that has Spanish terms for the output.
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.
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🤔
Thanku
You’re welcome!
I was able to edit the Number to Text formula to accept my country's currency without using a manual method.
Can I add United States Dollars in the front
Combine the text with concat or …. See if this helps Join Cell Values with CONCATENATE, CONCAT or TEXTJOIN Functions
ruclips.net/video/4GAjQtMgGsQ/видео.html
I think you can delete Dollar from the code
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!