Unable to Change Date Format in Excel ? You need to watch this | Microsoft Excel Tutorial

In some scenarios you will not be able to change date format in excel because the date will be formatted in text. In this tutorial im teaching you how to change date using the Text to column option in excel.
Date Formatting tutorial: • How to Change Date For...

Пікірлер: 719

  • @MITutorials
    @MITutorials2 жыл бұрын

    If this video has solved your problem consider supporting my channel by pressing the THANKS Button above.

  • @mohammedabdulrub4217

    @mohammedabdulrub4217

    Жыл бұрын

    Thanks 👍🏻

  • @paramsingh9430

    @paramsingh9430

    10 күн бұрын

    No solved my problem ,,,can you give Rs40 now.

  • @bryanpicon9644
    @bryanpicon96444 жыл бұрын

    Bro, I've spent almost 2 hours trying to format my file, I cannot believe it was that easy! Thank you so much!

  • @SIMRANKAUR-eg7nc

    @SIMRANKAUR-eg7nc

    3 жыл бұрын

    I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.

  • @alifalihgwin3098

    @alifalihgwin3098

    2 жыл бұрын

    Me too 😅

  • @swapnilbaviskar905

    @swapnilbaviskar905

    2 жыл бұрын

    Same with me. Feel so useless now 😅

  • @swapnilbaviskar905

    @swapnilbaviskar905

    2 жыл бұрын

    You have no clue how much efficiency this 1 minute video is going to add in our lives! 😅 Thanks a lot!!

  • @gchatila

    @gchatila

    Жыл бұрын

    LOOL i just told my friend exactly the same thing !! definitely the result is rewarding :)

  • @samluz1477
    @samluz1477 Жыл бұрын

    FINALLY someone answers an excel question with a short, to the point video. THANK YOU

  • @aramideakingbola3881
    @aramideakingbola38814 жыл бұрын

    You are a lifesaver! I have been doing this manually for 100s for data entry. Thanks, I appreciate it!

  • @alishasameer2927
    @alishasameer29273 жыл бұрын

    I’ve never commented on any KZread video before, but this video deserves all the appreciation! After spending more than 2 hours trying to figure it, I came across this video and it was GENIUS! Thank you so much!!!!

  • @caffeina75
    @caffeina754 жыл бұрын

    Thank you!! A life saver, I was going crazy without being able to format the date to a value I can use filters on!!

  • @rohra_aman
    @rohra_aman4 жыл бұрын

    Thank you so much for this ! 🙏🙏 You have literally saved so much time of everyone who was not able to fix this issue.

  • @Ruby-xx6xc
    @Ruby-xx6xc Жыл бұрын

    Oh my god! I can not thank you enough for this. You are a Legend. I am so grateful to have found this video. I spent 4 hours trying to fix it. THANK YOU.

  • @gitashreedey7148
    @gitashreedey71482 жыл бұрын

    Seriously, i was spending 4-5 hrs to just figure out how to format this date issue...u just solved it within 1 minutes.....thank you so much... :)

  • @sherreerobichaud9999
    @sherreerobichaud99994 жыл бұрын

    I have struggled with this for years and really appreciate this video. It fixed it in less than a minute. Thank you so much

  • @SIMRANKAUR-eg7nc

    @SIMRANKAUR-eg7nc

    3 жыл бұрын

    Check this 1. U will be further empowered.I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.

  • @lisataylor8058
    @lisataylor80582 жыл бұрын

    Thank you very much - I've struggled to come up with the answer to this and you've been the only one who has come up with what turns out to be a very simple solution as it seems to be a well kept secret!

  • @MITutorials

    @MITutorials

    2 жыл бұрын

    Glad I could help!

  • @osigbeleyusuf4812

    @osigbeleyusuf4812

    Жыл бұрын

    @@MITutorials thanks so much. This video was so helpful.

  • @AkshayKumar-ko2ny
    @AkshayKumar-ko2ny Жыл бұрын

    Bro I hve wasted 4 hours to Correct this no video is available but after seeing in your I hv changed in within 30 seconds only. God bless you dear

  • @raginishukla3580
    @raginishukla35804 жыл бұрын

    Great tip! I did get stuck trying to the date and this is very helpful. Thanks a lot!

  • @jeremyjimenezc9759
    @jeremyjimenezc97593 жыл бұрын

    TWO WORDS FOR YOU: THANK YOU My gf spent multiple weeks trying to fix this and this quick tutorial helped us out. Like

  • @robinbabbitt3614
    @robinbabbitt36144 жыл бұрын

    Thank you so much!!! This is exactly what I needed to know!

  • @mohindamaher1341
    @mohindamaher1341 Жыл бұрын

    Thank you for sharing. Your instructions was simple, short and straight to the point. Thanx

  • @Ohmystarz1
    @Ohmystarz15 жыл бұрын

    just saved an hour of my life thank you.

  • @abdulmuti1
    @abdulmuti14 жыл бұрын

    Thank you very much, I was changing each cell at a time, it was going to take me a lifetime lol. Thank you.

  • @jasonhofmeyer7355
    @jasonhofmeyer73553 жыл бұрын

    The amount of time you just saved me is ridiculous!!!! Thanks!!!!!!

  • @dogwater4429
    @dogwater44293 жыл бұрын

    Big props for this, this perfectly solves the problem I was having!

  • @antnauman
    @antnauman6 жыл бұрын

    I was stuck for a day. Thank you SO MUCH!

  • @hidayahroslen3791
    @hidayahroslen37913 жыл бұрын

    Totally save a lot of my time. Been searching for this for 2 days 👍

  • @syedsaqibali1482
    @syedsaqibali1482 Жыл бұрын

    Thank u soo much. Searched number of websites on google and videos on youtube but could not find the solution. You solved the issue in 1 & half minute. Thanks.

  • @axelrivera3796
    @axelrivera37964 жыл бұрын

    Thank you man, can't believe it's so easy to do, i've been having this question for over a month!!!! XD

  • @SIMRANKAUR-eg7nc

    @SIMRANKAUR-eg7nc

    3 жыл бұрын

    I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video..

  • @kavithakavi-tl6tq
    @kavithakavi-tl6tq2 жыл бұрын

    ,I was doing and searching for 2hours but unable to do finally got good video it's really helpful.. thank you bro ..

  • @motivationalflows
    @motivationalflows2 жыл бұрын

    You are fantastic! I have been trying to figure this out myself for a day and your video made me happy yet annoyed of myself too! 😅 I should have watched your video one day ago.

  • @anushavittal835
    @anushavittal8354 жыл бұрын

    Thank you so much..you are a savior..I used to take 45mins to manually change the format using f2 key..now it took hardly a min..thank you 😊

  • @SIMRANKAUR-eg7nc

    @SIMRANKAUR-eg7nc

    3 жыл бұрын

    Check this 1. U will be further empowered.I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.

  • @neelamdossani1264
    @neelamdossani12644 жыл бұрын

    Thank you so much. This option will replace so many other steps I used to do to change the Date Format.

  • @tajsay
    @tajsay4 жыл бұрын

    thank you so much ...after spending lot of time finally here I met with your video which saved me

  • @ewulotanyemi4375
    @ewulotanyemi43754 жыл бұрын

    Hi, I have spent almost a week trying to convert my text to date, thanks for saving my project and day. Thanks. I have watched some many videos on youtube but you killed for me. Thanks again

  • @SIMRANKAUR-eg7nc

    @SIMRANKAUR-eg7nc

    3 жыл бұрын

    Check this 1. I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.

  • @ishtiaqhameed8308
    @ishtiaqhameed83084 жыл бұрын

    Thank youuuuu soo much dear... As I was weekly make Reports and suffering from these date formet issues.. Today you Resolve my problem. Thank you

  • @praneethag9103
    @praneethag91034 жыл бұрын

    Thank you so much!! i was struggling with formatting and this made my task easy

  • @KT-iu2ov
    @KT-iu2ov4 жыл бұрын

    This was straight to the point and helpful. I left a Like. Tks.

  • @vincentgoergen7390
    @vincentgoergen7390 Жыл бұрын

    Super helpful, just saved me at least a day of headaches with some complex Excel sheets!

  • @metasebi
    @metasebi2 жыл бұрын

    THANK YOU, THANK YOU, THANK YOU. I searched for 1 hour until I found your video.

  • @MITutorials

    @MITutorials

    2 жыл бұрын

    You are welcome!

  • @brma1892
    @brma18922 ай бұрын

    Thank you! Yours is the only instruction that was able to solve this for me!

  • @Hasan-db4vv
    @Hasan-db4vv3 жыл бұрын

    Excellent! Precise and very helpful!

  • @Rudrasantani2599
    @Rudrasantani259910 ай бұрын

    Saw many videos but finally u made my struggle successful.... Thank you so much 🙏🏻

  • @sajjadali8655
    @sajjadali86552 ай бұрын

    The only video I felt like leaving a thank you message. Thanks for the help brother you saved me so much time.

  • @gianmarcorandon9776
    @gianmarcorandon97765 жыл бұрын

    thank you! you're a genius!!

  • @anuragarya6995
    @anuragarya69953 жыл бұрын

    Liked this video. To the point. Quick and simple.

  • @EagleAmor
    @EagleAmor5 жыл бұрын

    Thank you for the great tip!

  • @HG51_
    @HG51_3 жыл бұрын

    Thank you this was exactly what I was looking for!

  • @stephaniejeannevirata5816
    @stephaniejeannevirata58165 жыл бұрын

    thank you! this helped me big time!

  • @nataliecaron2489
    @nataliecaron24893 жыл бұрын

    Oh my dear ! God bless you. Your video is quick, clear, simple. EXCELLENT... I was scratching my head big time. THANK YOU SO MUCH

  • @SIMRANKAUR-eg7nc

    @SIMRANKAUR-eg7nc

    3 жыл бұрын

    I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.

  • @Jayl__
    @Jayl__4 жыл бұрын

    Omg this is amazing I was struggling with this for a good 40 mins. Thank you!!!!!

  • @mortasche

    @mortasche

    4 жыл бұрын

    Oh yeah, me too. Got an excel file from a colleague and I would still be struggling to get that scatter chart done if it wasn't for this video. Awesomeness cubed!

  • @deovrat1000
    @deovrat10002 жыл бұрын

    Thank you so much! I was struggling for more than an hour over this issue!!

  • @vijiselvaraj4036
    @vijiselvaraj40364 жыл бұрын

    Thank You so much! was going insane on my file!! It is helpful & saved lot of time! :)

  • @312349
    @3123493 жыл бұрын

    Thank you so much! You have me sooo much time and energy! Best of luck to you!

  • @maggiekerrigan6489
    @maggiekerrigan64892 жыл бұрын

    OMG, thank you. You solved my problem. Couldn't figure out why cell formatting wasn't doing anything! This worked!

  • @amywalker9493
    @amywalker94933 жыл бұрын

    Wow been trying to format sales date column all day and you helped me out :D appreciate it

  • @KateDrewThis
    @KateDrewThis4 жыл бұрын

    Thank you! I thought I new all of this stuff and I couldn't figure out why it wasn't working! THANK YOU!

  • @zackpryde7957
    @zackpryde7957 Жыл бұрын

    Thanks for this - extremely useful solution. I use it for budgeting purposes, and I struggled to find a good fix to formatting dates that are in different forms.

  • @simplyrolling441
    @simplyrolling4414 жыл бұрын

    I knew i wld find this on youtube bcoz of marvels like u..thnx boss..

  • @mafiosaorg6312
    @mafiosaorg63122 жыл бұрын

    Thanks for this short clip fixing this issue. Spot on. Follow this exactly and its sorted.

  • @user-ev9fc3hn9w
    @user-ev9fc3hn9w3 жыл бұрын

    Great video! Well done! Helped me save loads of time by this 1 minute video. You are a lifesaver lol

  • @MITutorials

    @MITutorials

    3 жыл бұрын

    Great to hear!

  • @MrJjk333
    @MrJjk3335 жыл бұрын

    Works like a charm! Thanks!!

  • @BhavikDavey
    @BhavikDavey3 жыл бұрын

    Thank you bro. That's really a worthy video for those who work with huge data.

  • @Praveen_Mangal
    @Praveen_Mangal4 жыл бұрын

    Wah bhai wah gajab You solved my problem in which got stucked for 1.5 hours thanks bro

  • @damilolaodili559
    @damilolaodili5592 жыл бұрын

    Thank you so much, man. Saved so many hours of my time.

  • @nimrazeeshan6253
    @nimrazeeshan62536 жыл бұрын

    Thanks for your help Man!!

  • @serene1429
    @serene142922 күн бұрын

    Thank you!! This is short and informative!

  • @madsm.8815
    @madsm.88155 жыл бұрын

    awesome! thank you so much!

  • @polinasemenova2697
    @polinasemenova26973 жыл бұрын

    Thank you!!!!!! I've been struggling the whole day before this!

  • @MatCaveGaming
    @MatCaveGaming3 жыл бұрын

    You just brought resolution to battle I have been fighting with Excel for the past 2 days. Thank you!!!!

  • @huipinghsieh8450
    @huipinghsieh84502 жыл бұрын

    big thanks! I was struggling with this for a while. it's really helpful!

  • @leylaaytun
    @leylaaytun4 жыл бұрын

    Thank you very much. Really saved my time and good to know such useful tip! appreciated!

  • @shreyaoberai460
    @shreyaoberai4605 жыл бұрын

    this is damn useful. i tried so many other ways but this worked. thanks alot

  • @waxterhan
    @waxterhan4 жыл бұрын

    This really helped. Thank you

  • @krittimamekanontchai464
    @krittimamekanontchai4645 жыл бұрын

    Thank god for your VDO! Really appreciate!!

  • @rohitraj-ig8to
    @rohitraj-ig8to4 ай бұрын

    thank you soo much for this useful information in a short and simple way !!!

  • @Sunny_786
    @Sunny_7864 жыл бұрын

    Very Helpful, i finally got solution after seen your video, Thank you very much.

  • @evaob2711
    @evaob27112 жыл бұрын

    Great! Tutorial still relevant and well explained. Thanks

  • @azharayub2095
    @azharayub20955 жыл бұрын

    save my day and made my day...thank you

  • @pallavishetty9003
    @pallavishetty90035 жыл бұрын

    Thanks. Saved lots of time

  • @vinitvaidya5101
    @vinitvaidya51013 жыл бұрын

    HELPED A LOT. Thanks!!!!!

  • @ManikandanRaju
    @ManikandanRaju5 жыл бұрын

    Thank you so much for the video.

  • @ganeshkumarmiriyala3607
    @ganeshkumarmiriyala3607 Жыл бұрын

    Thank you. This is just what I needed!

  • @lovexin81
    @lovexin814 жыл бұрын

    Lifesaver! Thanks man!

  • @paulboutros6093
    @paulboutros60932 жыл бұрын

    Hello, thx for the video I am looking to inputbox date into a range, I am looking the format "12/12/2021", I did the txtToColumn part, then I went to cell format and CUSTOM, and chose the "mm\dd\yyyy" and the format I got was "12d12y2021". any suggestions?

  • @fjtenou
    @fjtenou2 жыл бұрын

    Genius!! i've struggled with this for so long!!

  • @ramyasumith6302
    @ramyasumith63024 ай бұрын

    Short Crisp and To the Point.. Great work and Thank you so much

  • @llacinkilic
    @llacinkilic7 ай бұрын

    Thank you so much brother. You've saved me hours for this. Appraciate it!

  • @Cutebhavy
    @Cutebhavy3 жыл бұрын

    Very important information ,i have spend many hours to do this.....thanks 👍

  • @MITutorials

    @MITutorials

    3 жыл бұрын

    Glad it was helpful!

  • @Sally115a
    @Sally115a5 жыл бұрын

    A lifesaver! Thanks

  • @samuelkodjoe1645
    @samuelkodjoe16454 жыл бұрын

    my goodness......i've been looking for this!!............thank you!!!! ..............y're GOOD!!

  • @deeachannel9833
    @deeachannel9833 Жыл бұрын

    Thank you, I needed this information, and it helped!

  • @giovannipalmisano4182
    @giovannipalmisano41822 жыл бұрын

    I was looking for this for very long time. Thank you!!!

  • @AmbitiousKells
    @AmbitiousKells5 жыл бұрын

    THANK YOU THANK YOU THANK YOOUUU!!

  • @janakmadushan3306
    @janakmadushan33066 күн бұрын

    Thank you!

  • @shakeeshalott4565
    @shakeeshalott45655 жыл бұрын

    Thank you exactly what I needed

  • @jessicastagnaro5610
    @jessicastagnaro56103 жыл бұрын

    Thank you so much for this video, my IT department couldn't figure it out, so thank you!!

  • @MITutorials

    @MITutorials

    3 жыл бұрын

    wow ! That's Great to hear!

  • @jojo-tl5ei
    @jojo-tl5ei3 жыл бұрын

    Nice and concise. Thanks!! 👍

  • @waltermorales9849
    @waltermorales98492 жыл бұрын

    I love you! Thanks!

  • @angf9471
    @angf94712 жыл бұрын

    Great little tutorial, thanks so much!

  • @nishajhunjhunwala4423
    @nishajhunjhunwala44233 жыл бұрын

    Thank you so much! It was REALLY helpful!! Thanks, again.

  • @Azsharah
    @AzsharahАй бұрын

    Dude, freaking genius! Thank you so much!

  • @arismuhammad4540
    @arismuhammad4540 Жыл бұрын

    thank you so much..very helpful!

  • @harighotad
    @harighotad3 жыл бұрын

    Thanks dear I faced such problem many times. Now I got solution.

  • @JasonHunter-wl2wl
    @JasonHunter-wl2wl2 ай бұрын

    Thank you!!