Today, Denver asks how to convert a number in Excel to words such as "three thousand four hundred sixty five dollars and thirty two cents". In Episode #1431, Bill shows us a cool knowledge base article with the answer to solve this issue. This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!
Transcript of the video:
MrExcel Podcast is Sponsored by Easy-XL.
Learn Excel from MrExcel Podcast, Episode 1431: Numbers to Words.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen, and today's question's sent by Denver.
Denver says, "I want to convert those numbers into words, like they do on the second line of a check".
He says, "I don't want to spend any money, I don't want to buy any of those utilities out there that do this.
Is there a cheap way to do it?
Yeah, there's a really cheap way to do it.
Every time I run into this situation, I do the exact same thing-- we're going to go out, we're going to launch Google or whatever search engine you like, and we're going to search for "spellnumber".
All one word.
If you want, you can do “spellnumber microsoft”, but it's right there-- it's the second result today.
Okay, now, don't be freaked out that this is VBA-- yeah it's VBA, but you don't have to know anything about the VBL.
All you have, to be able to do is select some text.
I'm going to select all of this code here at the beginning-- right there, Ctrl+C to copy-- we go back to Excel.
Alright.
Alt+F11 gets me to VBA, Insert, Module, Ctrl+V to paste, that's it.
File, Close, and return to Microsoft Excel.
Then, we just do it here-- I'll just do right here-- =SpellNumber( that cell.
Close print.
Ctrl+Enter there to enter everywhere, and it all works.
Here, let's just do some =RANDBETWEEN 2000,99000 and every time I press F9 it automatically updates.
Alright?
There's nothing cheaper than that.
A littlle knowledgebase article that's been around at Microsoft.
I remember using it back in the '90s.
They update it for each new version of Excel.
Anytime I need it, just paste it in there and I'm good to go.
Well, hey, I want to thank you for stopping by, I want to thank Denver for sending that question in, I'll see you next time for another netcast from MrExcel.
Learn Excel from MrExcel Podcast, Episode 1431: Numbers to Words.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen, and today's question's sent by Denver.
Denver says, "I want to convert those numbers into words, like they do on the second line of a check".
He says, "I don't want to spend any money, I don't want to buy any of those utilities out there that do this.
Is there a cheap way to do it?
Yeah, there's a really cheap way to do it.
Every time I run into this situation, I do the exact same thing-- we're going to go out, we're going to launch Google or whatever search engine you like, and we're going to search for "spellnumber".
All one word.
If you want, you can do “spellnumber microsoft”, but it's right there-- it's the second result today.
Okay, now, don't be freaked out that this is VBA-- yeah it's VBA, but you don't have to know anything about the VBL.
All you have, to be able to do is select some text.
I'm going to select all of this code here at the beginning-- right there, Ctrl+C to copy-- we go back to Excel.
Alright.
Alt+F11 gets me to VBA, Insert, Module, Ctrl+V to paste, that's it.
File, Close, and return to Microsoft Excel.
Then, we just do it here-- I'll just do right here-- =SpellNumber( that cell.
Close print.
Ctrl+Enter there to enter everywhere, and it all works.
Here, let's just do some =RANDBETWEEN 2000,99000 and every time I press F9 it automatically updates.
Alright?
There's nothing cheaper than that.
A littlle knowledgebase article that's been around at Microsoft.
I remember using it back in the '90s.
They update it for each new version of Excel.
Anytime I need it, just paste it in there and I'm good to go.
Well, hey, I want to thank you for stopping by, I want to thank Denver for sending that question in, I'll see you next time for another netcast from MrExcel.
