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
If this video has solved your problem consider supporting my channel by pressing the THANKS Button above.
@mohammedabdulrub4217
Жыл бұрын
Thanks 👍🏻
@paramsingh9430
10 күн бұрын
No solved my problem ,,,can you give Rs40 now.
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
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
2 жыл бұрын
Me too 😅
@swapnilbaviskar905
2 жыл бұрын
Same with me. Feel so useless now 😅
@swapnilbaviskar905
2 жыл бұрын
You have no clue how much efficiency this 1 minute video is going to add in our lives! 😅 Thanks a lot!!
@gchatila
Жыл бұрын
LOOL i just told my friend exactly the same thing !! definitely the result is rewarding :)
FINALLY someone answers an excel question with a short, to the point video. THANK YOU
You are a lifesaver! I have been doing this manually for 100s for data entry. Thanks, I appreciate it!
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!!!!
Thank you!! A life saver, I was going crazy without being able to format the date to a value I can use filters on!!
Thank you so much for this ! 🙏🙏 You have literally saved so much time of everyone who was not able to fix this issue.
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.
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... :)
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
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.
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
2 жыл бұрын
Glad I could help!
@osigbeleyusuf4812
Жыл бұрын
@@MITutorials thanks so much. This video was so helpful.
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
Great tip! I did get stuck trying to the date and this is very helpful. Thanks a lot!
TWO WORDS FOR YOU: THANK YOU My gf spent multiple weeks trying to fix this and this quick tutorial helped us out. Like
Thank you so much!!! This is exactly what I needed to know!
Thank you for sharing. Your instructions was simple, short and straight to the point. Thanx
just saved an hour of my life thank you.
Thank you very much, I was changing each cell at a time, it was going to take me a lifetime lol. Thank you.
The amount of time you just saved me is ridiculous!!!! Thanks!!!!!!
Big props for this, this perfectly solves the problem I was having!
I was stuck for a day. Thank you SO MUCH!
Totally save a lot of my time. Been searching for this for 2 days 👍
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.
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
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..
,I was doing and searching for 2hours but unable to do finally got good video it's really helpful.. thank you bro ..
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.
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
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.
Thank you so much. This option will replace so many other steps I used to do to change the Date Format.
thank you so much ...after spending lot of time finally here I met with your video which saved me
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
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.
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
Thank you so much!! i was struggling with formatting and this made my task easy
This was straight to the point and helpful. I left a Like. Tks.
Super helpful, just saved me at least a day of headaches with some complex Excel sheets!
THANK YOU, THANK YOU, THANK YOU. I searched for 1 hour until I found your video.
@MITutorials
2 жыл бұрын
You are welcome!
Thank you! Yours is the only instruction that was able to solve this for me!
Excellent! Precise and very helpful!
Saw many videos but finally u made my struggle successful.... Thank you so much 🙏🏻
The only video I felt like leaving a thank you message. Thanks for the help brother you saved me so much time.
thank you! you're a genius!!
Liked this video. To the point. Quick and simple.
Thank you for the great tip!
Thank you this was exactly what I was looking for!
thank you! this helped me big time!
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
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.
Omg this is amazing I was struggling with this for a good 40 mins. Thank you!!!!!
@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!
Thank you so much! I was struggling for more than an hour over this issue!!
Thank You so much! was going insane on my file!! It is helpful & saved lot of time! :)
Thank you so much! You have me sooo much time and energy! Best of luck to you!
OMG, thank you. You solved my problem. Couldn't figure out why cell formatting wasn't doing anything! This worked!
Wow been trying to format sales date column all day and you helped me out :D appreciate it
Thank you! I thought I new all of this stuff and I couldn't figure out why it wasn't working! THANK YOU!
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.
I knew i wld find this on youtube bcoz of marvels like u..thnx boss..
Thanks for this short clip fixing this issue. Spot on. Follow this exactly and its sorted.
Great video! Well done! Helped me save loads of time by this 1 minute video. You are a lifesaver lol
@MITutorials
3 жыл бұрын
Great to hear!
Works like a charm! Thanks!!
Thank you bro. That's really a worthy video for those who work with huge data.
Wah bhai wah gajab You solved my problem in which got stucked for 1.5 hours thanks bro
Thank you so much, man. Saved so many hours of my time.
Thanks for your help Man!!
Thank you!! This is short and informative!
awesome! thank you so much!
Thank you!!!!!! I've been struggling the whole day before this!
You just brought resolution to battle I have been fighting with Excel for the past 2 days. Thank you!!!!
big thanks! I was struggling with this for a while. it's really helpful!
Thank you very much. Really saved my time and good to know such useful tip! appreciated!
this is damn useful. i tried so many other ways but this worked. thanks alot
This really helped. Thank you
Thank god for your VDO! Really appreciate!!
thank you soo much for this useful information in a short and simple way !!!
Very Helpful, i finally got solution after seen your video, Thank you very much.
Great! Tutorial still relevant and well explained. Thanks
save my day and made my day...thank you
Thanks. Saved lots of time
HELPED A LOT. Thanks!!!!!
Thank you so much for the video.
Thank you. This is just what I needed!
Lifesaver! Thanks man!
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?
Genius!! i've struggled with this for so long!!
Short Crisp and To the Point.. Great work and Thank you so much
Thank you so much brother. You've saved me hours for this. Appraciate it!
Very important information ,i have spend many hours to do this.....thanks 👍
@MITutorials
3 жыл бұрын
Glad it was helpful!
A lifesaver! Thanks
my goodness......i've been looking for this!!............thank you!!!! ..............y're GOOD!!
Thank you, I needed this information, and it helped!
I was looking for this for very long time. Thank you!!!
THANK YOU THANK YOU THANK YOOUUU!!
Thank you!
Thank you exactly what I needed
Thank you so much for this video, my IT department couldn't figure it out, so thank you!!
@MITutorials
3 жыл бұрын
wow ! That's Great to hear!
Nice and concise. Thanks!! 👍
I love you! Thanks!
Great little tutorial, thanks so much!
Thank you so much! It was REALLY helpful!! Thanks, again.
Dude, freaking genius! Thank you so much!
thank you so much..very helpful!
Thanks dear I faced such problem many times. Now I got solution.
Thank you!!