Grab the file I used in the video from here 👉 pages.xelplus.com/numbers-to-words-file
@muwanguzitimothy2973
2 ай бұрын
thanks Leira, I have been following you for almost 3 years, but you have added weight to knowledge about excel... thanks alot
@mondaypopbrav3244
Ай бұрын
Hi Leila, how do I write the cents in words too instead of using the 50/100. So I want to write fifty cents
@artyafridi
5 жыл бұрын
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
@kHoPhAe
4 жыл бұрын
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!
@ckokse
5 жыл бұрын
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!
@yiubili1
5 жыл бұрын
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
@HappyheartbyNida
5 жыл бұрын
You can use spell number addin. I have it
@muneerdahot320
3 жыл бұрын
Plz tell me date in words formula without vba
@rabdu2002
5 жыл бұрын
Many thanks for Mr. Pete & Mrs. Leila, we waited too much until getting this formula.
@jayrichzhanra4988
5 жыл бұрын
Pete, this is amazing! seems this is the first time in Excel history!
@erendiz79
5 жыл бұрын
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...
@LeilaGharani
5 жыл бұрын
Thank you for the contribution!
@erendiz79
5 жыл бұрын
@@LeilaGharani you are welcome Leila
@bertkutoob
5 жыл бұрын
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...?
@petemenhennet9792
5 жыл бұрын
bertkutoob Yes, payment certificates and contracts. Useful in invoices as well, I suppose.
@sanjaykumartripathy6087
5 жыл бұрын
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.
@benabedmhamed2360
5 жыл бұрын
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
@AqibNuh
2 жыл бұрын
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.
@MusicforMe123
5 жыл бұрын
If Pete was your student it says a lot about the teacher, thank you so much for sharing!
@LeilaGharani
5 жыл бұрын
I'm very honored to have Pete in my class.
@bijaysharma9017
5 жыл бұрын
Kindly convert the two decimal numbers to words too, so that the formula becomes complete in all respect.
@TheLastAnt
11 ай бұрын
Did you find the solution? I need that too.
@bakthapuri
5 жыл бұрын
Hi Leila, Why don't you make a video on web scraping with VBA..? it's really helps a lot... Please make it for us..
@Soulenergy31
5 жыл бұрын
Amazing Pete!!! Great work!!! And thanks Leila for the crystal clear explanation!
@bradleycampbell357
2 жыл бұрын
Thank you for all your great videos on youtube. They have helped more than I thought would be possible. I am having trouble opening the link to download the formula. Is there another way to download it?
@LeilaGharani
2 жыл бұрын
Glad to hear that! Thank you. The file is at the bottom of this blog post: www.xelplus.com/Excel-Formula-Convert-Numbers-to-Words/
@kurapikanostrad4592
5 жыл бұрын
Any improvements or shortened one? Thanks a lot pete and Leila. Its been an honor to learn this for free.
@slslrilil
5 жыл бұрын
Super excited @Leila. Convey regards to Pete as well.
@NjaanAdima
5 жыл бұрын
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.
@omarelijah9754
3 жыл бұрын
I know Im quite randomly asking but do anyone know of a good site to stream new movies online ?
@shadrackawunyo7786
5 жыл бұрын
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
@LeilaGharani
5 жыл бұрын
It brings everyone together :)
@macky2green
5 жыл бұрын
Heilo, Leila and everyone. Sorry to be off-topic. Most of us have Google accounts and it has a suite of several services. 1. Contacts/Address Book - I want to export my whole Google contacts/address book into Excel, organize and update them there, and import it back to Google. I've read from some people on-line that importing it back to Google from an Excel spreadsheet mismatches/misaligns fields. True? 2. Bookmarks - Surely, most are outdated now. Everything is easier on Excel. I need a similar solution to question # 1. 3. Calendar - Is it also possible to export-import my Google Calendar entries to/from Excel? TIA.
@hmghmgforum4688
5 жыл бұрын
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
5 жыл бұрын
You're very welcome! You're absolutely right on both points. I'm grateful to Pete for sharing his solution with us.
@junreyquilicot4775
5 жыл бұрын
@@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
@ricos1497
5 жыл бұрын
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!
@petemenhennet9792
5 жыл бұрын
Rico S Thanks
@TechnoNetworkGuy
2 жыл бұрын
Some Keyboard shortcuts which improves productivity :- kzitem.info/news/bejne/1GuQ22qLqIegl6A
@smartbuildindiagoa3886
5 жыл бұрын
Amazing work by Pete and thanks Leila for sharing the same. Leila, can you help us convert the formula for use In India as Rupees currency. It would be of great help to us.
@Estimation_costing_mithun
5 жыл бұрын
Simply amazing and thank you for sharing. Hats off Pete.
@fahadpalladium2
2 жыл бұрын
OMG 😱. I wonder how long it took him to compose this monstrosity!
@noelleclark3603
4 ай бұрын
Thank you for this. I've been searching the comments, but how can I replace the decimal showing as 67/100, for example and make it say 67 cents?
@LeviDeGuzman.2102
3 ай бұрын
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.
@denisedrew729
10 ай бұрын
This formula is working perfectly in my spreadsheet on my PC but when I send the same spreadsheet to a colleague, it moves 2 decimals i.e. R422.26 becomes Four Rand & 22/100 on their computer. Does anyone have any ideas how to fix this?
@JamesOGant
Жыл бұрын
It doesn't work correctly in mine. It is sometimes off by 1 and there is no need for there to be "and" between digits which are not separated by a decimal. Like 344.46 is read as "Three Hundred and Forty Three and 46/100". While 111.73 is read as "One Hundred and Eleven and 73/100".
@carlo_migliari81
7 ай бұрын
My idea is to divide the number to convert in group of three digits: one digit covers the hundreds, the second covers the teens and the last one deals with ones. Using QUOTIENT, MOD and LENGTH with some AND conditions you can repeat the pattern also for hundreds of thousands and hundreds of millions. It is possible to wrap all together inside a LET formula. Anyway my solutions uses helper columns (that can be declared inside the LET)
@lieandy79
Ай бұрын
Hi Leila.. how to add cents with word ? like 1,000.45 usd = one thousand and forty five cents usd
@tw9823
6 ай бұрын
Thank you so much it works. How can we get decimal places in words as well. I.e. £20.35 thirty-five pence rather than 35/100m
@FarhanKhan-hu2er
3 жыл бұрын
Why excel not use it as default formula .... Its basic need while printing invoices.... Pls do something...
@maliktheleader
Жыл бұрын
Hi, This is video is very useful, I have question, How to identify the .00 like 123.45 One hundred and Twenty Three USD and Forty Five Cents Please assist.
@lelenbates3367
11 ай бұрын
I was struggling with this formula. I replaced B3 with J7 for my workbook and it was showing the formula text so I tried again and it was showing zero dollars and cents even with the formula showing J7. I realized that I was referencing the work book I copied from. So to ensure I did repeat the mistake I copied the formula to Word and them pasted from word to my Excel workbook. It works! I was getting ready to try VBA.
@beyobeya
5 жыл бұрын
When this goes out to everyone, I hope they won't forget to give Pete a credit, just like you did. And a cookie.
@LeilaGharani
5 жыл бұрын
I hope so too. It should be called the "Pete" Formula!
@petemenhennet9792
5 жыл бұрын
Mark Anthony cookie sounds great 😎
@NenadKralj
5 жыл бұрын
Holly wheelbarrows (I just needed this) thank you Pete and Leila 👍😎
@Tube-id7su
5 жыл бұрын
Looooovvvvvvvvvveeeeeeeeee YYYYYYooooooouuuuuuuu....... Wonderfull tip... since loooooooong time i searched.
@sanjaybarge5487
5 жыл бұрын
Thirteen hundred crore four hundre twelve lakh twenty five thousand seven hundred fifty five
@SumonAhmed-c4x
Жыл бұрын
Its a great tutorial. But what should i do for if i want to show value crore. Like-1,20,40,651 in word- one crore twenty lakh forty thousand and six hundred fifty one taka only
@zxcvbnmmasdfghjkl
5 жыл бұрын
That is the craziest formula in excel hand(jobs) down!
@HasanKhan-qb6tg
3 жыл бұрын
How can we get formula....
@LeilaGharani
3 жыл бұрын
Just click on Show More below the video and follow the link to my blogpost.
@kiranbandekar2434
3 жыл бұрын
Please tell me, How to Change Formula In Lakhs & Crore In indian Rupees ..(Million Or Euro Not Support in india)
@TheUnicleo
Жыл бұрын
I 'm surprised 😯 by people ready to apply such a huge nested formula, instead of learning and applying well structured VBA user defined function!
@shubhsjbp
5 жыл бұрын
Good one, but at 3:50 you could have simply dragged the cell by holding handle to a cell above, or simply cut pasted the thing :) but the find-replace thing would be quite helpful if you want to put this into an excel table!!
@robertgraham7245
5 жыл бұрын
That was my first thought. Sure seems like a simpler way.
@figlermaert
5 жыл бұрын
This would be a great opportunity to add as a custom function if you had a need to do this all the time so you don’t have to worry about accidentally messing up the formula if doing a lot of copy and pasting.
@ironwood9
3 жыл бұрын
@Sam Stevens Did you do it yet?
@figlermaert
3 жыл бұрын
@@ironwood9 nah. I don’t have a need to do this formula
@hermanho3996
2 жыл бұрын
seem complicate, I convert number to text by adding 10000000, then convert to text, use a 1 to 99 in word lookup table can do the same.
@katerina6495
5 жыл бұрын
Thank you so much Pete and Leila, great exercise, it is really amazing
@paramveerssachdeva
5 жыл бұрын
Pete is a sheer Genious, Thanks a lot for sharing.
@dkc_1978
3 жыл бұрын
Liela , India currency uses Lak and Crore, its nor working properly, please do something for correction.
@senayfekadu6859
3 жыл бұрын
How did she change it back to normal after she changed the reference from B3 to to other cell and put back the equal sign i couldn't operate normally no more and it seems like she only clicked one thing to get back to normal
@mostafa.gothman
2 жыл бұрын
thank you so much very helpful is there is any way for donation as to support doing like these helpful things
@haiderkhalilebrahimsalman1961
5 жыл бұрын
2 likes one for you and one for Pete, well thanks
@LeilaGharani
5 жыл бұрын
Thank you for the double like :)
@ansar311
2 жыл бұрын
People who have thumps down may be illiterates who can't understand 😊
@aspentree8159
10 ай бұрын
Hello, thank you for sharing!! Do you have the formula in a form that can be copied
@subashsd635
5 жыл бұрын
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,
@LeilaGharani
5 жыл бұрын
Thank you! I am sure Pete will appreciate the kind words too.
@mohammedsohail3911
5 жыл бұрын
This is really a great formula thnks .. leila and pete
@jkcvlctzn
Жыл бұрын
Can anyone help me to fix the end (34/100)...Please.?????
@juarezr61274
5 жыл бұрын
Wow Pete rocks!
@LeilaGharani
5 жыл бұрын
He sure does!
@6833573
5 жыл бұрын
Thank you so much for such a nice trick. God bless you
@BOXMANcrew
Жыл бұрын
Great work but if you could solve the formula as current formula is not able to convert my decimal in to words
@dharminderkumar9370
2 жыл бұрын
this formula is not perfect for indian rupees please make correct for indian currency and upload again excel file
@aboelmagd100
5 жыл бұрын
Your performance is more than creative
@LeilaGharani
5 жыл бұрын
Glad you like it. Pete did all the heavy lifting!
@juzergandhi
4 жыл бұрын
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!
@tonytai180
8 ай бұрын
Hi Leila, thanks for the sharing. What if I want to put the "cents" as well?
@myexcelacademy69
5 жыл бұрын
SUPER AMAZING, THANK YOU LEILA AND PETE!!!!!!!
@followthetruth3283
5 жыл бұрын
This is first when I saw a formula for the currency to Words instead of VBA. Really a great job.
@LeilaGharani
5 жыл бұрын
Me too! All thanks to Pete!
@catherineestanislao2347
2 жыл бұрын
i followed the formula, however, it doesn't work on me. Can you help me?
@mehdihammadi6145
5 жыл бұрын
What wonderful formula! Thank you for sharing and many thank to Peter
@stefanopantaleoni9232
3 жыл бұрын
Imagine combining it with lambda function!!!
@orihayatobikiri403
Жыл бұрын
Should of used vlookup, that's a lot of if writing...
@nareshrachagorla9853
5 ай бұрын
Can u plz help me to with the file or the formula, could not access the code
@charolaashish
3 жыл бұрын
i like it this video. you can help me in indian rupees formula....??
@farooqtahir538
2 жыл бұрын
Even with VBA you can do it more easily.Just a waste of time
@virenderverma755
2 жыл бұрын
this is indeed a great effort. Kudos to Pete and thank you for sharing it with us all.
@NooraniCentreAdmin
Жыл бұрын
is office 2007 is workable this formula????
@shabbirkanchwala-abwaab6263
5 жыл бұрын
Beyond imagination. Marvelous Lots of thanks (More then length of formula 😅)
@LeilaGharani
5 жыл бұрын
Thank you!
@kvlpnd
5 жыл бұрын
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.
@markgreer6585
2 жыл бұрын
Pete & Leila: THANK YOU SO MUCH!!!! Exactly what I was searching for! Perfect code and perfect narrative!
@kommentfreak4869
2 жыл бұрын
ok, whats about the german way of speling numbers?
@ahmedkhalifa4519
Жыл бұрын
@1:50 lol that was crazy to see the formula taking the whole screen
@atultilkaan
4 жыл бұрын
Hi.. Leila Gharani, Thank you so much for this video. I had been looking for this in years and finally I came across your this video. Can I use this formula in my video? I mean I want to create a KZitem video where we need this formula. So can you use it?? Please let me know. Thank you.
@enriquedominguez9709
5 жыл бұрын
Thank you for sharing Pete and Leila.
@ohdjrp4
5 жыл бұрын
another excel wizard discovered!...thanks for sharing!
@LeilaGharani
5 жыл бұрын
Pete is certainly an amazing, creative and patient wizard!
@sarwaranam5712
4 жыл бұрын
how can i convert... '99,99,99,999' to 'Ninety Nine Crore Ninety Nine Lac Ninety Nine Thousand Nine Hundred and Ninety Nine Taka Only'
@heikoheimrath7514
5 жыл бұрын
great formula 😀
@onlinetraders7183
3 жыл бұрын
She did not gave the formula if any one have please paste in comments
@LearnYouAndMe
4 жыл бұрын
Great effort, but in my opinion, this can be better done using VBA UDF. UDF provides a clean , flexible and user-friendly way to output something if it is not inbuilt in Excel.
@prabirray7858
2 жыл бұрын
can you please convert it to crore and lakh instead of million ?
@agnisdesigners7938
5 жыл бұрын
Most awaited and required solution given by you. Thank you so much.
@LeilaGharani
5 жыл бұрын
You're very welcome! I'm thankful to Pete for sharing.
@pangpang-np7ei
3 жыл бұрын
How to improvise to spell out the cents in full text, like 0.55 - Fifty Five Cents ?
@jpnweb
3 жыл бұрын
i have the same question
@charmedforever4245
2 жыл бұрын
Me too
@Ticky66MN
5 жыл бұрын
Wow, thank you Pete. Amazing work!
@jorgenieto4122
Жыл бұрын
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!
@LeilaGharani
Жыл бұрын
Happy to help :)
@denverpili3510
Жыл бұрын
I did it also on 2012 , using. Excel 2007 :(
@باهم_بیاموزیم
5 жыл бұрын
Thank you Pete and Leila for sharing a new point of view of excel
@LeilaGharani
5 жыл бұрын
You're very welcome!
@farooqtahir538
2 жыл бұрын
It can be easily done in google sheet and then can be copy in excel
Пікірлер: 851