7 Clever Excel Custom Formatting Tricks (Advanced)

[@sansnomnull2799]

Finally someone clearly explained the custom formatting, not just how but also why. Thank you!

[@trumpexcel]

Thanks for commenting... Glad you found the video useful :)

[@keithau8159]

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot @t wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at @t ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

[@keithau8159]

Hello,my dearest Indian Friend,how are you.Happy new year 2021 to you and to your family."Tai chi?Num ma stair?Kee sai ho?T-Cool.Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek du.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he,kai ah mei two mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei Hindi,Hindo,Nepalese art dee hei.Mei India kam kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Eight lai jar dar kam ho dar hei,kar jar kee,saw jar dar hung bo ho tek kee hung.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it ,mei ban lee.So kar lee ah.Ug ly hip see dai mei link it."

[@Itsmuhdd]

One of the few people has the clear and awesome way to explain and deliver the information & knowledge! Thank you sir!

[@ravindrakunwar4847]

you are one of two youtubers for whom I have hit the bell icon. Bro you are king of formatting

[@supplychainsys]

I have been using custom formatting for years but your explanation was the best explanation I have seen on the subject. Provides insights on how to combine multiple formatting techniques. Great stuff! Thanks

[@ianodonoghue7299]

This is an incredible video. This really helped me in work as an accountant I wanted my excel workings to match exactly the figures in the PDF without effecting others. Thank you so much

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

[@rachitthakur3779]

You have been an amazing trainer❤️🙏 #respect

[@sushilnoatia6076]

@@rachitthakur3779 v

[@karthikiyer9502]

Hi sumit. Needless to say, you are doing a great job. Keep it up. Your videos are very useful. Presentation is crisp and clear. I calculate more in excel like many of us. Just wondering if there is any option that would pop up instead of save your file when we are done calculation in that file. Pop up like, " Did you cross check your calculations" reminding to verify the sheet once again and then close the sheet. Kindly make a video or let me know if there is way out like that. Thank you Karthik.

[@quduslawal2591]

Sumit Bansal is an Excel Sage. Hats off

[@sanjaybetme]

Yes indeed 👍🏻👍🏻👍🏻🔥🔥🔥

[@GosCee]

Very well presented! This is the best Custom Number formatting explanation I have seen. Thank you very much, Sumit.

[@motalibcomputer6278]

Finally I find a good thing which is truly helpful for us

[@phey6304]

he knows perfectly what he is doing, a real guru in excel.. awesome presentation very brief clear and concise

[@trumpexcel]

Thanks for commenting Penny... Glad you found the video useful!

[@keithau8159]

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple and no wonder draw tourists come to Holly Khilasa temple to vist at all,as long as modification of all kinds of hotels,motel facilities of all classes,definitely make big money globally at all,particularly from Europe,North America,Japan,Korea@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become flourish in different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century,if not famous geologist,cosmology and archeologist not interested to visit the greatest nation of India.Last century 80-2 thousand ,movies as Fly and Lara Croft: Tomb Raider still have good memory in 21th@@@@@

[@deepaky129]

Great explained with concept. Watched so many videos about custom cell formatting but the way you explained is amazing.

[@sanjaysrivastava9671]

Your deliberation and presentation are just excellent. Just by watching your videos, I have been able to learn it to a respectable level. It may be noted that I am from mini drafter and calculator era. Hats off

[@trumpexcel]

Thanks for the kind words Sanjay... Glad you found the video useful!

[@srmchinni3]

Really, your work is awesome and I see that all your videos are with extraordinary content. I will surely buy a coffee for you, soon.

[@HarpreetSingh1991]

Your videos best than the short videos I watch. You have explained the reason behind why we write this or that . Thank u & I subscribed and liked the video.

[@UniversalEngineer]

This is FANTASTIC! Clearly communicated and demonstrated. So helpful. Thank you! 👏👏👏

[@FsoOmar]

I've seen this custom format (hide) ;;; but kept forgetting it after months of not using it. Your explanation at ~ 3:30 will make it stick to my head forever. Thanks a lot! 🙏

[@jennydrumm7223]

Oh, you're simply amazing! Before lunch I watched another of your videos and it was so great and now this one? I've been doing things like this the hard way forever! You're a terrific instructor; thanks!

[@keithau8159]

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot @t wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at @t ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

[@pprathamesh]

Super like ALL your videos. Your difference lies in the innovative application of the same function for which there are 100 other videos on how to use it.

[@dontown1531]

I have been using Excel since 1993 & even learned a couple of things from this video.

[@trumpexcel]

Excel is such a well developed tool and I keep learning new things about it every now and then... Glad you found the video useful!

[@keithau8159]

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot @t wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at @t ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

[@ethiohelptube794]

Thanks for giving us a new and important knowledge!!! You have no idea how much that’s important to me!!!

[@muhammada.muhammad6287]

extremely great, finally I understood it clearly

[@trumpexcel]

Glad the video helped 🙂

[@jamesthomas8249]

Was just finishing a profit margin review for 2020. These formats really made an impressive report. Thanks for your hard work.

[@keithau8159]

Hello,my dearest Indian Friend,how are you.Happy new year 2021 to you and to your family."Tai chi?Num ma stair?Kee sai ho?T-Cool.Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek du.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he,kai ah mei two mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei Hindi,Hindo,Nepalese art dee hei.Mei India kam kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Eight lai jar dar kam ho dar hei,kar jar kee,saw jar dar hung bo ho tek kee hung.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it ,mei ban lee.So kar lee ah.Ug ly hip see dai mei link it."

[@adnanali3971]

Really great. Thank you very much. Keep sharing such insights. Many prays from Pakistan.

[@shibilsnoopy3973]

Finally i found the excel king

[@jdsingh8189]

beautifully explained

[@AlejandroMora29]

Sumit, you are a wizard!

[@vijaykishan8649]

Your explanation is superb Sumit. I always appreciate your work. Thank You.🙏🙏🙏🙏🙏

[@raziajeena9861]

been using excel for a while and learned lots. thanks

[@trumpexcel]

Glad you found the video useful!

[@tlim1945]

Very good tips. Delivered clearly and concisely. Easy to follow. Very few videos are like that. Your videos are one of the best.

[@vramarathnam]

useful areas covered. excellent esplanation. thank you

[@shoaibwarsi3338]

Wow ,Excel training wasn't so easy before , I used to find it difficult but now my thinking is changed , Excel is totally fun thank you sir

[@mayur7673]

thanks buddy .. last one was really good

[@smitapatwardhan975]

Your videos are very interesting and to the point

[@rashidfaridkhan2664]

Simple & Excellent way..Thanks Sumit

[@AkachukwuUdechukwu]

Best explanation on this subject

[@trumpexcel]

Thanks 😊 Glad you found the video helpful!

[@excelworx8712]

Very informative. Knew the hiding using ;;; but learning number formatting for the first time

[@trumpexcel]

Thanks for commenting... Glad you found the video useful!

[@musajuma7374]

Simple and Excellent way to teach Thanks for your efforts you did for us,

[@Lalit_4166]

Wonderfully explained

[@wayneedmondson1065]

Hi Sumit. Excellent custom formatting tips! Thanks for sharing :)) Thumbs up!!

[@MostofaKamal-ll5dx]

It's so much helpful indeed. Thank you very much.

[@drjaganmohanraomeda615]

excellently explained, thank you

[@w.a.schull1357]

Excellent explanations of these very useful techniques.

[@trumpexcel]

Glad you found the video useful!

[@ramamohanpathapati7694]

Thank you for clear explanation

[@stanlomas]

Very useful. Thank you. Will be using them today.

[@pchatterjee4150]

Very well explained! Thank you so much.

[@thiyakup7333]

Very Nice teaching, it's very useful

[@vijaykishan8649]

Good Explanation. I really appreciate all your videos Sumit. Keep up the good work for us. Thank You.

[@trumpexcel]

Thanks for commenting Vijay... Glad you found the video useful!

[@venkatraj5491]

good video with best knowledge

[@IvanCortinas_ES]

Excellent explanation. The magic is back. Thank you very much for these tutorials Sumit!

[@trumpexcel]

Thanks for commenting Iván... Glad you found the video useful :)

[@swathic1621]

Wisely explained ..worth watching bro.. keep it up👍

[@Jack-er2uj]

Thank you very much for sharing your knowledge.

[@vinaykhadilkar]

I liked the video. Very well explained and to the point.

[@shahzadsami5613]

100% having a worth to watch, High Quality Information

[@FsoOmar]

Thank you for this awesomely usueful vid. Please make more vids of custom formatting tricks.

[@alialbayati9368]

Thanks Sumit for making this video.

[@trumpexcel]

Glad you found the video useful!

[@kprakashsha]

Its explained very very very excellent

[@uolaod]

Really it so an amazing explanation even though if you done a mistake during the tutorial still we learn. Mush thankful

[@jbcosta51]

Very good explanation.

[@nitinparmar5117]

Your all videos are very useful for us thanks for such an amazing videos.

[@trumpexcel]

Thanks for commenting Nitin... Glad you found the video useful!

[@h33t18]

Thanks for the tips!! I needed to hide non numerical data and this will help. No matter what I do my cells remove the negative sign - ??

[@askulasaatwik8thc644]

Thank you Awesome Excel tricks!

[@ashokkhegde]

Unbelievable Sir. Awesome

[@trumpexcel]

Thanks for commenting Ashok... Glad you found the video useful!

[@jawaidiqbal945]

Nice way to make understand Well done

[@jarna555]

very nicely explained,Good job

[@rashiedasuliman4138]

Thank you for tutorial, it is very helpful. Always appreciate your tutorials.

[@mail2vj574]

This is Gold.

[@subhashthangadipally4974]

After Rakesh Yadav bhayya videos... really helpful inputs thanks I am new subscriber

[@trumpexcel]

Thanks for commenting Subhash... Glad you found the video useful!

[@mdks1012]

Awesome! Very informative. Learnt a lot. Thanks so much.

[@trumpexcel]

Glad you found the video useful!

[@jiajiaphotography]

Very clearly explained and easy to apply to daily work

[@trumpexcel]

Glad you found the video useful!

[@saifdogar8376]

Good one. I even i knew m9st of them but new learning by very easy and descriptive methods

[@mohanv3614]

Very well explained with reasons

[@trumpexcel]

Thanks for commenting Mohan... Glad you found the video useful!

[@zohurulislam7628]

Very useful, Very advance. Thank you sir, Thank you so much.

[@trumpexcel]

Thanks for commenting... Glad you found the video useful!

[@دراساتاجتماعية-ز9ل]

Always with you new and useful

[@trumpexcel]

Glad you found the video useful!

[@keishrich]

Helpful video. Thank you.

[@koolbro343]

Damn, Scott's score is perfect

[@broto8]

Wow I am quite impressed ... this will be such a valuable info for me in the future!

[@trumpexcel]

Thanks for commenting Subroto... Glad you found the video useful!

[@gvinodnair]

Wow! That's a lots of unknown tricks and techniques. Thanks for sharing @TrumpExcel

[@ramk1969]

excellent tips sir...Thanks....

[@israelaguilera9613]

Amazing work!

[@dhapumdhap]

Simply Too Good and Simple! 👌👏👏👏

[@luistavvares]

So glad for this. I had problem with "Show numbers in Millions or Billions" did not work...

[@jeaniminerales5578]

VERY USEFUL SIR

[@vijayarjunwadkar]

Great video with really smart tips for custom formatting! Thanks a lot for sharing! 😊👍

[@Froilan355]

Great, very educational

[@mrmusicloverable]

Some powerful stuff. Thank you very much!

[@trumpexcel]

Glad you found the video useful!

[@sravankumar1767]

Nice Explanation. Bro

[@alfredoas9635]

WoW new trick... Thank You 🙏🏽

[@marynelrocero8092]

So useful, thank u so much!

[@trendingpublic1069]

Thanks for the information sir ❤️

[@SunilKumar-pj5gz]

Great Sir 👌

[@hubertg7100]

Great Tutorial!

[@debopomsaha8694]

thanks for clear explaination

[@trumpexcel]

Glad you found the video helpful 🙂

[@monirhossain9850]

Thank you for sharing amazing tips in Excel.

[@trumpexcel]

Glad you found the video useful!

[@vikaasb2016]

Simply sublime !!

[@Adi-jk2ef]

Amazing tricks 👍

[@ahmedabdelrahman829]

Keep going, it's helpful

[@rabdu2002]

Hi Mr. Sumit many thanks for the wonderful video tutorial, please from where you get the check mark & how you replaced in format cell. please reply

[@PankajKumar-tr7bg]

Amazing Video

[@pratikbante2711]

Thank you Sirji 🙏😊

[@BijendraSah4u]

thank you so much for this tricks !!! it's really awesome !!! however i am seeking some more custom format ( need accounting format but except not make all the number double digit if not available . ex. if number are like this 100 - make 100 1000- make 1,000 10.50 make 10.50 0 make -