Convert NUMBERS to WORDS in Excel | No VBA (free file included)

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.

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!

🚩Let’s connect on social:

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

[sanjaykumartripathy]

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.

[Soulenergy]

Amazing Pete!!! Great work!!! And thanks Leila for the crystal clear explanation!

[ckokse]

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!

[jayrichzhanra]

Pete, this is amazing! seems this is the first time in Excel history!

[juzergandhi]

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!

[Estimation_costing_mithun]

Simply amazing and thank you for sharing. Hats off Pete.

[virenderverma]

this is indeed a great effort.
Kudos to Pete and thank you for sharing it with us all.

[rabdu]

Many thanks for Mr. Pete & Mrs. Leila, we waited too much until getting this formula.

[markgreer]

Pete & Leila:
THANK YOU SO MUCH!!!!
Exactly what I was searching for!
Perfect code and perfect narrative!

[mehdihammadi]

What wonderful formula! Thank you for sharing and many thank to Peter

[KL]

Wow! Thank you Leila for this information, great video as Absolutely perfect 👌🏼

[katerina]

Thank you so much Pete and Leila, great exercise, it is really amazing

[artyafridi]

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

[hmghmgforum]

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!

[shadrackawunyo]

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 I am highly impressed

[rolandestrellado]

That's wow! Thank you for sharing this video and the formula from Mr. Pete. God bless you.

[jayrichzhanra]

Thank you Mr. Peter Menhennet for sharing!

[ricos]

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!

[salamehabikaram]

Amazing, i’ve been waiting this for long time ago. And brilliant job from Pete👍🏻

[michelyounes]

Thanks, Pete and Leila for sharing this great formula! 👌👍👏