Convert NUMBERS to WORDS in Excel | No VBA (free file included)
Вставка
- Опубліковано 3 сер 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
ONE Excel formula that converts numbers to words AND it does it, WITHOUT VBA and macros - without helper cells and without Microsoft Excel array formulas. Download the free Numbers to Words Converter workbook provided below and use the formula in your own files.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/numbers-to-...
00:00 Convert numbers to text in Excel
01:17 The formula
02:20 Changing currency
02:51 Applying formula to many cells
04:44 How the formula works
05:07 Excel LEFT function
05:27 Excel MID function
05:59 Excel TEXT function
07:10 Excel CHOOSE function
🔍 What You'll Learn:
- Step-by-step guide to converting numbers into words using a single-cell formula.
- How to adapt the formula for different currencies and remove decimal places.
- Easy methods to update and apply the formula in your spreadsheets.
👷♂️ Perfect for:
- Excel enthusiasts looking for smart, efficient solutions.
- Professionals in construction, accounting, and other fields where detailed number representation is key.
- Excel users at all levels who love learning new, powerful techniques.
Many thanks to Peter Menhennet for sharing his solution with us. I'm really grateful to have subscribers who are willing to share their knowledge and solutions with others. THANK YOU!
For the VBA version check out this post from Microsoft: bit.ly/MSSupportNumbersWords
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Grab the file I used in the video from here 👉 pages.xelplus.com/numbers-to-words-file
thanks Leira, I have been following you for almost 3 years, but you have added weight to knowledge about excel... thanks alot
Hi Leila, how do I write the cents in words too instead of using the 50/100. So I want to write fifty cents
What the kind of expertise you have in Excel.... Pete... Great...I appreciate the degree of dedication in testing such a lengthy formula.... Thanks both for sharing such a useful formula.
I salute you and bow to you out of sheer respect. Thank you Mr. Peter Menhennet for sharing and thank you Ms. Leila Gharani for propagating this awesome formulae. God bless you!
Many thanks for Mr. Pete & Mrs. Leila, we waited too much until getting this formula.
Pete, this is amazing! seems this is the first time in Excel history!
Amazing Pete!!! Great work!!! And thanks Leila for the crystal clear explanation!
this is indeed a great effort.
Kudos to Pete and thank you for sharing it with us all.
Pete & Leila:
THANK YOU SO MUCH!!!!
Exactly what I was searching for!
Perfect code and perfect narrative!
Simply amazing and thank you for sharing. Hats off Pete.
What wonderful formula! Thank you for sharing and many thank to Peter
Wow! Thank you Leila for this information, great video as usual!!!!! Absolutely perfect 👌🏼
This is absolutely amazing! I did not find any solution without VBA until now. I can just imagine the amount of testing Pete had to do for this insane formula to work. Thank you!
Thanks very much for sharing your brilliant work, i don't have a chance to use it, but the thought process is just brilliant. /salute
You can use spell number addin. I have it
Thank you so much Pete and Leila, great exercise, it is really amazing
I DONT HAVE THAT WORDS IN WHICH I THANKS YOU.
BLESS YOU SISTER FOREVER MAY ALLAH GIVE YOU LONG LIFE
I AM PROUD OF YOU
Thank you Mr. Peter Menhennet for sharing!
Wow, thank you Pete. Amazing work!
Wow... Finally a solution that works!! Thank Pete and Leila. You guys are god sent
Thanks, Pete and Leila for sharing this great formula! 👌👍👏
That's wow! Thank you for sharing this video and the formula from Mr. Pete. God bless you.
IT's like watching a serie, each episode resolves a greater problem. Thanks so much for the Tip. I'm glad I sign up for your classes.
You're very welcome Marcus. I'm glad you find the tutorials helpful.
It's impressive, no doubt. Looping through the characters in any string - numbers or letters - is extremely difficult to achieve in Excel. Well done Pete.
Well delivered, too, of course!
Rico S Thanks
Amazing, I once built a formula in older version of Excel with use of nested ifs, though there wasn't any choose then. The formula was just about long like this.
Excellent. Thank you very much, for teaching this amazing trick. Expecting some more AWESOME tricks/tips from you.
Really this is amazing! I did not find any solution without VBA until now. Thanks for providing the formula without VBA code
Some years ago, I made similar thing by using text's formulas in french and Arabic. But VBA stay more interesting. Thank you any way
OMG!!!! Thanks a lot Pete. Thank you Gharani. I need this badly!! Thanks a lot. Love your work..
Awesome. Few years ago I was searching all over the internet for this. Unfortunately, I could not find, so I ended up creating my own VBA to convert the numbers.
Thank you PETE and thank you Leila for explaining it.
Pete and Leila, great work... this eliminates a necessity to run VBA and thus anybody can do it now! You are amazing as always!
Thank you :)
Sir Pete, yours so amazing. Thank you so much!!!!
Ms. Leila, you're an angel... I thought i have no other choice but to use vba.
Thanks to this...
SUPER AMAZING, THANK YOU LEILA AND PETE!!!!!!!
Ms. Gharani, the videos you make have significantly helped me in my career. I've watched your videos for that past few years and they have given me a step up on others. Thank you for these videos.
You're most welcome Benjamin. Many thanks for your ongoing support.
Very generous of Pete for sharing
Pete is a sheer Genious, Thanks a lot for sharing.
Beautiful work, complex but still, beautiful. Thanks for the share.
Holly wheelbarrows (I just needed this) thank you Pete and Leila 👍😎
Amazing, i’ve been waiting this for long time ago. And brilliant job from Pete👍🏻
Salameh Abi Karam Thank you.
Great work. Thank you Peter Menhennet
Super excited @Leila. Convey regards to Pete as well.
Leila!!!! Did you say this giant huge mind blowing formula was created by a construction professional? Amazing!!! Pete, you have raised my hopes.... Excel does magic in all industries, not just for computer and accounting professionals...... I am highly impressed
It brings everyone together :)
Wow! Amazing! Thank you. Just two things come to my mind now. 1. Sharing is caring. 2. One need not re-invent the wheel again. Thank you Peter Menhennet for sharing the wheel so that others need not re-invent!
You're very welcome! You're absolutely right on both points. I'm grateful to Pete for sharing his solution with us.
@@LeilaGharani I want to use the formula you generously demonstrated but I can't copy the gigantic formula. Please I need help.... this is my mail junrey.quilicot2@gmail.com
If Pete was your student it says a lot about the teacher, thank you so much for sharing!
I'm very honored to have Pete in my class.
This is first when I saw a formula for the currency to Words instead of VBA. Really a great job.
Me too! All thanks to Pete!
This is Beautiful!!! Pete is a genius! I've been looking for this for sometime now.
Ok, at this point I am very certain Leila developed the Excel program and maintains it. I don't think any Microsoft Excel programmer can match her skills.
Thank you very much!
Leila Gharani
This is so amazing...!!! This is the first time I have ever seen in excel history in my life, thank you for share your knowledge with us.
Well, Pete did all the heavy lifting. I just presented the results.
Most awaited and required solution given by you. Thank you so much.
You're very welcome! I'm thankful to Pete for sharing.
Thanks Pete and Laila for sharing this amazing solution.
You're very welcome.
A bit complex at first sight but after a simplified view by Leila it perfectly makes sense... Thanks Peter for the hard work and sharing this and thanks Leila for the explaination.
You're very welcome. Anyway, Pete did all the heavy lifting.
Thank you Leila, thank you Pete!
Heartly Thanks to Mr PETE for this wonderful formula creation and also thank to Ms Leila to bring this up through your videos. It makes simple work now
Our pleasure :)
The best instructor ever - Thank you very much
No phrases...just a BIG word "BRILLIANT!" Thanks so much, Ms Leila and Mr Pete.
You're very welcome. Pete did all the heavy lifting!
A big shout out for Pete and Leila you rock.
thank you Pete.
thanks Leila
Thank you for sharing Pete and Leila.
Thank you Pete and Leila for sharing a new point of view of excel
You're very welcome!
Thank you, this helps me alot. God bless you, your team and also the creator of this formula.
Classic, and lot of learning too. Good to invest time to understand it thoroughly. Thanks a lot.
You're very welcome Vivek :)
Thank you so much for such a nice trick. God bless you
It's working. Thank you for your help. It saves lots of energy and reduce the chances of mistakes as well.
Appreciated!
Our pleasure :)
Thank you Pete and thanks to all others contributing to the creation and development of these formulas! :)
😘
Wonderful work here. Thanks Pete and Leila!
You're very welcome!
That's incredible. Well done
This is incredible. Thank you so much to both for sharing.
Our pleasure!
Maybe this is the right video I've been waiting for. Thank you for sharing 👍👍👍...
This was one of my concerns that used to share everywhere. Thank you for this effort. But I still believe this should be part of inbuilt.
Another concern I always express is that, adding a name to the grouping the data. The reader should know, without expanding the data columns/rows, what is grouped. Excel should allow adding a name option while grouping the data.
I know Im quite randomly asking but do anyone know of a good site to stream new movies online ?
Thank you Leila and of course many thanks to Pete!
You're very welcome!
Thank you for this amazing video... Well explained...
Well done, thanks a lot for you and Mr Pete, I m very happy when watching your explanation, then when click the link below it's so well organised and clear.
Cool, thanks!
Thank you so much Leila, Pete, Jim! Very big help :)
Thank you so much. Your code works. Such a big help in check issuances. God bless you always.
Wow, that's a long formula. Thanks Pete for creating such a monster and thanks Leila for posting.
You're very welcome. It definitely is a monster formula :)
It must have taken hours for creating this formula. I don't think I have the stamina to write it down so I will just copy and paste it.
Many thanks for video.
Amazing!!! This is out of the world...All hail King Pete!!!👏
Very true! He's the best.
Any improvements or shortened one?
Thanks a lot pete and Leila. Its been an honor to learn this for free.
another excel wizard discovered!...thanks for sharing!
Pete is certainly an amazing, creative and patient wizard!
Amazing formula created by PETE. Thanks a lot for sharing it.
Pete is GREAT!
This was absolutely amazing!
Thank you so very much! This was very, very helpful.
Thanks for this Leila! More power🎉
it's really amazing and helpful, thank you so much .
This is so great, good job Pete. you just saved me from sleepless nights
I wish I could press thumbs up more then one time ! Pete solved an age old debate and you shared it so well !
I'm already happy about that one thumbs up :)
Thank you so much!! GOD BLESS YOU GUYS
Brilliant, Kudos to Pete
so beautiful Leila, genius work. I appreciate you share this with us.
My pleasure 😊
Thanks Leila! Very great full to you for sharing this video. This video is very use full
This is absolutely amazing! thank you from My Heart
Pete and I are glad it's helpful.
Thanks a lot Peter Menhennet
Thanku very much Leila and Peter for this wonderful information☺️
You're very welcome!
GREAT EFFORT THANK YOU SO MUCH FOR SHARING THIS IDEA!!!! GOD BLESS YOU ALWAYS...
Many thanks tp Pete and team
Mam really I am searching this formula, I could not seach it today my searching is end, from you I got very amazing trick, thank you from bottom of my heart. God bless you, thank you mam...
You're very welcome! I'm glad it is helpful.
Dear Leila,
Please convey a heartfelt thank you to Pete M for this wonderful, wonderful formula. He must have spent days to perfect it. Salute to his patience.
Thank you to you too for taking the initiative for sharing the same.
Regards,
Thank you! I am sure Pete will appreciate the kind words too.
You are the king of Excel 🌹😍😍😍
im so greatfull with this, this is a big help for me. thanks leila special to pete.
may god bless you all
Our pleasure!
Thanks for sharing this good-logic solution. So many things are possible with Excel
Very true!
This was really good one
I do also appreciate Pete for helping us
Good video
Glad you like it. Pete is the best.
Thank you so much for your kind help!
Thank you Pete and Leila. What a great help.
Our pleasure!