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!
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!
@@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
Wow, I can’t thank you enough for this formula! I’ve been trying to figure it out for over 3 years, and you just gave it away for free. You’re amazing!
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
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!
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.
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!
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!
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.
The student becomes the master. Been looking for years for this solution. If there was a Nobel prize for excel formulas. Pete would definitely get my vote. 👍 Pete the legend
@@LeilaGharani Thanks for replying and for sharing the gem. There was something I wanted to bring up. I am on a Mac using the latest Office 365. I struggled to get the formula working. First , “command A” wasn’t selecting all. Then when I pasted it in a new document. It wouldn’t paste as a formula but as text and was incomplete, no paste special configurations would work. After about an hour of frustration, as only the Billions formula seemed to copy. I fixed this by comparing the Billions formula with the other two and noticed some differences in the spaces. I went into the formula bar, deleted all the spaces where the formula started on a new line instead of continuing. Copied it all by highlighting as I still couldn’t select all and then got it to paste in a new spreadsheet. changed my currency to KWD and 000/1000 as we use three decimals here. Hope this helps anyone that runs into the same problem. I can only imagine how frustrating it must have been to come up with this. I can’t thank you enough for sharing.
Ms Gharani, many thanks for sharing this amazing formula. You have been my ultimate guide in excel for the last few months. A million thanks to Pete for creating this genius formula.
it is amazing! it' s fabulous! I don't know how to say thanks for your very professional and simply saying informative and useful teaching video I just say salute and bow to you and and Pete
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.
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,
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...
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.
That is cool. I also had a student back in 2003 show me a similar formula, but this mathematician had a formula that centered around the MOD function to accomplish a single cell number to text formula. It NEVER seases to amazing me what humans can do with Excel : ) Thanks for the video, Teammate!
@@LeilaGharani This was a Seattle mathematician who was NOT registered in my class and come into my office hour to show it to me back in about 2003. I am not sure if I still have the workbook he showed me. I still have all the folders of files from my classes from way back then, but I am not sure if the file he showed me is in one of them. I will look...
Crikey! I did something similar but using an array a few years ago and getting the logic right was, to say the least, mind boggling. My head still aches at the thought. Getting it into a single formula would have blown all the fuses, so 👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏 Pete, let me guess. Contractor's payment claims? If the bottom line in numerals doesn't exactly match the words then the client tosses the claim back and the contractor doesn't get paid. It's bad enough if everyone is speaking one language but when the engineer is English, the contractor is Afrikaans and the client is isiZulu you surely do need this formula. Thanks Pete, where were you when I needed you...?
Wow!!! Hats of for coming up with this, let alone sharing it. As a side note, shame on Microsoft for not making this a default formula for a long time.
It has been almost over 3 years when i saw it first time. Since then "The Amount Word Solution" is always inspired me; "How Genius Mr. Pete is" ---- Bundle of Appreciation & Respect for him.
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
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.
wonderful. I converted this formula to display just the word of the number. 2314 = two three one four. Up to a 9 digit number. 9 lines of repetition, but super easy to read. I also put a If(count(A1)=1 then .... to ensure it is a number.Thanks
Oh my freaking goodness. Thanks for this info. I was struggling so much with the VBA thing damn!. Even copying from MS website and still doesn't work. You guys rock!
Thank you Mr. Pete and thank you Ms. Leila.... For me also this was a nightmare for a long time. Then I found a solution myself by using dget function. Now it has become more easy
@@LeilaGharani Its not only about the amazing usefulness; but there is so much to learn from this integrated function. I may need to modify this just a little to fit in Indian context; where 1] the currency symbol is prefixed 2] for numbers after decimal and 3] use of "and" which comes between Rupees and Paise. Thanks a lot. You're a billion dollar girl :)
Hi Pete... Great work! and I salute! I high appreciated its a big help. Thank you for sharing this. Thank you also Ms Leila for the clear explanation on how it works. By the way I added the LET function so that it only refences one cell.
for those working with a European formatting system, make a search and replace in the formula for "0.0" into "0,0" so you have the proper European decimal separator...
Hello miss Gharani from greece.Thank you from my heart for your excelent work. You help me to a lot of solutions. You have a friend to greece.You are welcome.George Mantafounis
Sincerely thanks to Pete, Leila, Jim M., Zafar Khan and Abdul Rahman Mohammed for creating and sharing this amazing formula. With Leila's explanation and everyone hardwork, I successfully further modify the formula to get my desired result. Thank you once again.
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.
At 3:40.. You explain how to change B3 to B4.. It can be easier.. Click on Cell B3 on the edge, you see arrows to move.. move cell b3 to B4. And all the references in the formula moves with it. After that, its easier to type new input. Always nice tutorials and learned lot .. Tnx and keep on :)
Umbelievable Leila, Veryy Useful for a fianancial officer in making bank transfer :-) so he has to put the amount in word :-). And it is flexible we can translate it many language :-) and currency
Thank you PETE! thank you Leilah. Has anyone in the community done this in Spanish. I'm trying to modify it myself, but Spanish is a very rich language. 500 + 26 = Quinientos Veintiséis
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
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
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
Wow, I can’t thank you enough for this formula! I’ve been trying to figure it out for over 3 years, and you just gave it away for free. You’re amazing!
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 :)
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!
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
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.
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!
Many thanks for Mr. Pete & Mrs. Leila, we waited too much until getting this formula.
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!
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
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.
The student becomes the master. Been looking for years for this solution. If there was a Nobel prize for excel formulas. Pete would definitely get my vote. 👍 Pete the legend
So true John! Pete is the best.
@@LeilaGharani Thanks for replying and for sharing the gem. There was something I wanted to bring up. I am on a Mac using the latest Office 365. I struggled to get the formula working. First , “command A” wasn’t selecting all. Then when I pasted it in a new document. It wouldn’t paste as a formula but as text and was incomplete, no paste special configurations would work.
After about an hour of frustration, as only the Billions formula seemed to copy. I fixed this by comparing the Billions formula with the other two and noticed some differences in the spaces. I went into the formula bar, deleted all the spaces where the formula started on a new line instead of continuing. Copied it all by highlighting as I still couldn’t select all and then got it to paste in a new spreadsheet. changed my currency to KWD and 000/1000 as we use three decimals here. Hope this helps anyone that runs into the same problem.
I can only imagine how frustrating it must have been to come up with this. I can’t thank you enough for sharing.
Ms Gharani, many thanks for sharing this amazing formula. You have been my ultimate guide in excel for the last few months.
A million thanks to Pete for creating this genius formula.
Pete, this is amazing! seems this is the first time in Excel history!
This is Beautiful!!! Pete is a genius! I've been looking for this for sometime now.
WOW! Pete worked his butt off for this. KUDOS to him. Thank You Leila for great daily training - as I call it :-) !!!
That was absolutely amazing! THANK YOU LEILA AND PETE!!! Thank you for sharing it. It saves lots of energy and time. Appreciated!
Our pleasure!
it is amazing! it' s fabulous!
I don't know how to say thanks for your very professional and simply saying informative and useful teaching video I just say salute and bow to you and and Pete
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.
Wow... Finally a solution that works!! Thank Pete and Leila. You guys are god sent
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.
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.
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.
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 :)
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
Amazing Pete!!! Great work!!! And thanks Leila for the crystal clear explanation!
Thank you Pete and Leila for sharing a new point of view of excel
You're very welcome!
Thanks Pete and Laila for sharing this amazing solution.
You're very welcome.
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.
That is cool. I also had a student back in 2003 show me a similar formula, but this mathematician had a formula that centered around the MOD function to accomplish a single cell number to text formula. It NEVER seases to amazing me what humans can do with Excel : ) Thanks for the video, Teammate!
Awesome. unimaginable!!!
Mega cool! If you happen to find the formula can you please share it with us?
@@LeilaGharani This was a Seattle mathematician who was NOT registered in my class and come into my office hour to show it to me back in about 2003. I am not sure if I still have the workbook he showed me. I still have all the folders of files from my classes from way back then, but I am not sure if the file he showed me is in one of them. I will look...
Crikey! I did something similar but using an array a few years ago and getting the logic right was, to say the least, mind boggling. My head still aches at the thought. Getting it into a single formula would have blown all the fuses, so 👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏👏
Pete, let me guess. Contractor's payment claims? If the bottom line in numerals doesn't exactly match the words then the client tosses the claim back and the contractor doesn't get paid.
It's bad enough if everyone is speaking one language but when the engineer is English, the contractor is Afrikaans and the client is isiZulu you surely do need this formula.
Thanks Pete, where were you when I needed you...?
bertkutoob Yes, payment certificates and contracts. Useful in invoices as well, I suppose.
Wow!!! Hats of for coming up with this, let alone sharing it. As a side note, shame on Microsoft for not making this a default formula for a long time.
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...
Pete & Leila:
THANK YOU SO MUCH!!!!
Exactly what I was searching for!
Perfect code and perfect narrative!
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 :)
Most awaited and required solution given by you. Thank you so much.
You're very welcome! I'm thankful to Pete for sharing.
Very generous of Pete for sharing
A big shout out for Pete and Leila you rock.
thank you Pete.
thanks Leila
Amazing formula created by PETE. Thanks a lot for sharing it.
Pete is GREAT!
It has been almost over 3 years when i saw it first time.
Since then "The Amount Word Solution" is always inspired me; "How Genius Mr. Pete is" ---- Bundle of Appreciation & Respect for him.
Thank you Pete for sharing your knowledge and thanks to our sister Leila for showing us how to work with...
You're very welcome. Pete is the best.
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 :)
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 ?
That's wow! Thank you for sharing this video and the formula from Mr. Pete. God bless you.
You are the king of Excel 🌹😍😍😍
another excel wizard discovered!...thanks for sharing!
Pete is certainly an amazing, creative and patient wizard!
Super excited @Leila. Convey regards to Pete as well.
wonderful. I converted this formula to display just the word of the number. 2314 = two three one four. Up to a 9 digit number. 9 lines of repetition, but super easy to read. I also put a If(count(A1)=1 then .... to ensure it is a number.Thanks
👍
Oh my freaking goodness. Thanks for this info. I was struggling so much with the VBA thing damn!. Even copying from MS website and still doesn't work. You guys rock!
Happy to help :)
Thank you Mr. Pete and thank you Ms. Leila.... For me also this was a nightmare for a long time. Then I found a solution myself by using dget function. Now it has become more easy
Our pleasure :)
Thanks Pete for taking so much efforts in building this formula and thanks Leila for sharing :)
I'm very grateful Pete shared this with us too :)
@@LeilaGharani Its not only about the amazing usefulness; but there is so much to learn from this integrated function. I may need to modify this just a little to fit in Indian context; where 1] the currency symbol is prefixed 2] for numbers after decimal and 3] use of "and" which comes between Rupees and Paise. Thanks a lot. You're a billion dollar girl :)
Sachin Vartak you're welcome.
Hi Pete... Great work! and I salute! I high appreciated its a big help. Thank you for sharing this. Thank you also Ms Leila for the clear explanation on how it works. By the way I added the LET function so that it only refences one cell.
for those working with a European formatting system, make a search and replace in the formula for "0.0" into "0,0" so you have the proper European decimal separator...
Thank you for the contribution!
@@LeilaGharani you are welcome Leila
this is indeed a great effort.
Kudos to Pete and thank you for sharing it with us all.
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 :)
Thanks for this Leila! More power🎉
Great Support, Much appreciated.
Many thanks tp Pete and team
Amazing!!! This is out of the world...All hail King Pete!!!👏
Very true! He's the best.
Thank you so much Leila, Pete, Jim! Very big help :)
GREAT EFFORT THANK YOU SO MUCH FOR SHARING THIS IDEA!!!! GOD BLESS YOU ALWAYS...
Excellent Effort made by you!
Really this is amazing! I did not find any solution without VBA until now. Thanks for providing the formula without VBA code
Heads off to PETE! you really create a marvel in excel
So true!
What wonderful formula! Thank you for sharing and many thank to Peter
Superb solution without VBA
Thanks Leila that's practically working 👍
You’re welcome 😊
Wonderful work here. Thanks Pete and Leila!
You're very welcome!
Simply amazing and thank you for sharing. Hats off Pete.
Hello miss Gharani from greece.Thank you from my heart for your excelent work. You help me to a lot of solutions. You have a friend to greece.You are welcome.George Mantafounis
I'm glad the tutorials are helpful George.
Sincerely thanks to Pete, Leila, Jim M., Zafar Khan and Abdul Rahman Mohammed for creating and sharing this amazing formula. With Leila's explanation and everyone hardwork, I successfully further modify the formula to get my desired result. Thank you once again.
Our pleasure :)
Thank you PETE and thank you Leila for explaining it.
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 Mr. Peter Menhennet for sharing!
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!
At 3:40.. You explain how to change B3 to B4.. It can be easier.. Click on Cell B3 on the edge, you see arrows to move.. move cell b3 to B4. And all the references in the formula moves with it. After that, its easier to type new input. Always nice tutorials and learned lot .. Tnx and keep on :)
Mindblowing! Fantastic! Excellent!
Glad you like it. Pete did all the heavy lifting!
@@LeilaGharani but still without you we would have not known about this. Kudos to Pete for doing such a mind blowing formula. Too good!
Maybe this is the right video I've been waiting for. Thank you for sharing 👍👍👍...
Any improvements or shortened one?
Thanks a lot pete and Leila. Its been an honor to learn this for free.
Thank you, this helps me alot. God bless you, your team and also the creator of this formula.
Thank you so much Leila .My problem solve easily .
Many thanks, dear Leila!
The best instructor ever - Thank you very much
Thanks a lot Peter Menhennet
Thank you Leila and of course many thanks to Pete!
You're very welcome!
Pete is a sheer Genious, Thanks a lot for sharing.
That's insane formula.. that guy is a legend
I know, right? Pete is amazing!
Absolutely amazing! Pro but he most amazing tool in excel
Pete deserves highest civilian award and nobel price
He sure does :)
Perfect. thanks a lot for this😍
Our pleasure :)
Umbelievable Leila, Veryy Useful for a fianancial officer in making bank transfer :-) so he has to put the amount in word :-). And it is flexible we can translate it many language :-) and currency
I'm glad it's helpful Mohamed.
Thank you Pete and thanks to all others contributing to the creation and development of these formulas! :)
😘
Worth the Like & Share! Thank you Pete & Leila
Yay, thanks!
@@LeilaGharani one thing i notice in terms of the centavos it can't be converted into words? Hope I made sense
Thank you for sharing Pete and Leila.
im so greatfull with this, this is a big help for me. thanks leila special to pete.
may god bless you all
Our pleasure!
Thank you Pete and Leila. What a great help.
Our pleasure!
Thank you PETE! thank you Leilah.
Has anyone in the community done this in Spanish. I'm trying to modify it myself, but Spanish is a very rich language. 500 + 26 = Quinientos Veintiséis
Here's in Spanish. Change A1 to your cell reference
=LET(
cell,A1,
Total,CHOOSE(LEFT(TEXT(cell,"000000000.00"))+1,,"Uno","Dos","Tres","Cuatro","Cinco","Seis","Siete","Ocho","Nueve")
&IF(--LEFT(TEXT(cell,"000000000.00"))=0,,IF(AND(--MID(TEXT(cell,"000000000.00"),2,1)=0,--MID(TEXT(cell,"000000000.00"),3,1)=0)," Cien"," Cientos "))
&CHOOSE(MID(TEXT(cell,"000000000.00"),2,1)+1,,,"Veinte ","Treinta ","Cuarenta ","Cincuenta ","Sesenta ","Setenta ","Ochenta ","Noventa ")
&IF(--MID(TEXT(cell,"000000000.00"),2,1)1,
CHOOSE(MID(TEXT(cell,"000000000.00"),3,1)+1,,"Uno","Dos","Tres","Cuatro","Cinco","Seis","Siete","Ocho","Nueve"),
CHOOSE(MID(TEXT(cell,"000000000.00"),3,1)+1,"Diez","Once","Doce","Trece","Catorce","Quince","Dieciséis","Diecisiete","Dieciocho","Diecinueve"))
&IF((--LEFT(TEXT(cell,"000000000.00"))+MID(TEXT(cell,"000000000.00"),2,1)+MID(TEXT(cell,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(cell,"000000000.00"),4,1)+MID(TEXT(cell,"000000000.00"),5,1)+MID(TEXT(cell,"000000000.00"),6,1)+MID(TEXT(cell,"000000000.00"),7,1))=0,(--MID(TEXT(cell,"000000000.00"),8,1)+
RIGHT(TEXT(cell,"000000000.00")))>0)," Millónes y "," Millónes "))
&CHOOSE(MID(TEXT(cell,"000000000.00"),4,1)+1,,"Uno","Dos","Tres","Cuatro","Cinco","Seis","Siete","Ocho","Nueve")
&IF(--MID(TEXT(cell,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(cell,"000000000.00"),5,1)=0,
--MID(TEXT(cell,"000000000.00"),6,1)=0)," Cien"," Cientos"))
&CHOOSE(MID(TEXT(cell,"000000000.00"),5,1)+1,,," Veinte"," Treinta"," Cuarenta"," Cincuenta"," Sesenta"," Setenta"," Ochenta"," Noventa")
&IF(--MID(TEXT(cell,"000000000.00"),5,1)1,
CHOOSE(MID(TEXT(cell,"000000000.00"),6,1)+1,," y Uno"," y Dos"," y Tres"," y Cuatro"," y Cinco"," y Seis"," y Siete"," y Ocho"," y Nueve"),
CHOOSE(MID(TEXT(cell,"000000000.00"),6,1)+1," Diez"," Once"," Doce"," Trece"," Catorce"," Quince"," Dieciséis"," Diecisiete"," Dieciocho"," Diecinueve"))
&IF((--MID(TEXT(cell,"000000000.00"),4,1)+MID(TEXT(cell,"000000000.00"),5,1)+MID(TEXT(cell,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(cell,"000000000.00"),7,1)+MID(TEXT(cell,"000000000.00"),8,1)+MID(TEXT(cell,"000000000.00"),9,1))=0,
--MID(TEXT(cell,"000000000.00"),7,1)0)," Mil "," Mil y "))
&CHOOSE(MID(TEXT(cell,"000000000.00"),7,1)+1,,"Uno","Dos","Tres","Cuatro","Cinco","Seis","Siete","Ocho","Nueve")
&IF(--MID(TEXT(cell,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(cell,"000000000.00"),8,1)=0,--MID(TEXT(cell,"000000000.00"),9,1)=0)," Cien "," Cientos "))&
CHOOSE(MID(TEXT(cell,"000000000.00"),8,1)+1,,,"Veinte y ","Treinta y ","Cuarenta y ","Cincuenta y ","Sesenta y ","Setenta y ","Ochenta y ","Noventa y ")
&IF(--MID(TEXT(cell,"000000000.00"),8,1)1,
CHOOSE(MID(TEXT(cell,"000000000.00"),9,1)+1,,"Uno","Dos","Tres","Cuatro","Cinco","Seis","Siete","Ocho","Nueve"),
CHOOSE(MID(TEXT(cell,"000000000.00"),9,1)+1,"Diez","Once","Doce","Trece","Catorce","Quince","Dieciséis","Diecisiete","Dieciocho","Diecinueve")),
Ciento,SUBSTITUTE(Total,"Uno Cientos","Ciento"),
Doscientos,SUBSTITUTE(Ciento,"Dos Cientos","Doscientos"),
Trescientos,SUBSTITUTE(Doscientos,"Tres Cientos","Trescientos"),
Cuatrocientos,SUBSTITUTE(Trescientos,"Cuatro Cientos","Cuatrocientos"),
Quinientos,SUBSTITUTE(Cuatrocientos,"Cinco Cientos","Quinietos"),
Seiscientos,SUBSTITUTE(Quinientos,"Seis Cientos","Seiscientos"),
Setecientos,SUBSTITUTE(Seiscientos,"Siete Cientos","Setecientos"),
Ochocientos,SUBSTITUTE(Setecientos,"Ocho Cientos","Ochocientos"),
Novecientos,SUBSTITUTE(Ochocientos,"Nueve Cientos","Novecientos"),
Veintiuno,SUBSTITUTE(Novecientos,"Veinte y Uno","Veintiuno"),
Veintidos,SUBSTITUTE(Veintiuno,"Veinte y Dos","Veintidos"),
Veintitres,SUBSTITUTE(Veintidos,"Veinte y Tres","Veintitres"),
Veinticuatro,SUBSTITUTE(Veintitres,"Veinte y Cuatro","Veinticuatro"),
Veinticinco,SUBSTITUTE(Veinticuatro,"Veinte y Cinco","Veinticinco"),
Veintiseis,SUBSTITUTE(Veinticinco,"Veinte y Seis","Veintiséis"),
Veintisiete,SUBSTITUTE(Veintiseis,"Veinte y Siete","Veintisiete"),
Veintiocho,SUBSTITUTE(Veintisiete,"Veinte y Ocho","Veintiocho"),
Veintinueve,SUBSTITUTE(Veintiocho,"Veinte y Nueve","Veintinueve"),
Millon,SUBSTITUTE(Veintinueve,"Uno Millónes","Un Millón"),
Mil,SUBSTITUTE(Millon,"Uno Mil","Mil"),
Calc,IF(RIGHT(Millon,2)="y ",LEFT(Millon,LEN(Millon)-2),Millon),
UPPER(LEFT(Calc,1))&LOWER(MID(Calc,2,LEN(Calc))))
Thank you for sharing your solution!
Great work. Thank you Peter Menhennet