Unable to Change Date Format in Excel ? You need to watch this | Microsoft Excel Tutorial
Вставка
- Опубліковано 19 лип 2024
- 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...
If this video has solved your problem consider supporting my channel by pressing the THANKS Button above.
Thanks 👍🏻
FINALLY someone answers an excel question with a short, to the point video. THANK YOU
Bro, I've spent almost 2 hours trying to format my file, I cannot believe it was that easy! Thank you so much!
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.
Me too 😅
Same with me. Feel so useless now 😅
You have no clue how much efficiency this 1 minute video is going to add in our lives! 😅 Thanks a lot!!
LOOL i just told my friend exactly the same thing !! definitely the result is rewarding :)
I’ve never commented on any UA-cam 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!!!!
You are a lifesaver! I have been doing this manually for 100s for data entry. Thanks, I appreciate it!
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.
I have struggled with this for years and really appreciate this video. It fixed it in less than a minute. Thank you so much
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.
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... :)
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!
Glad I could help!
@@MITutorials thanks so much. This video was so helpful.
THANK YOU, THANK YOU, THANK YOU. I searched for 1 hour until I found your video.
You are welcome!
TWO WORDS FOR YOU: THANK YOU
My gf spent multiple weeks trying to fix this and this quick tutorial helped us out. Like
Great tip! I did get stuck trying to the date and this is very helpful. Thanks a lot!
I was stuck for a day. Thank you SO MUCH!
Big props for this, this perfectly solves the problem I was having!
Thank you so much!!! This is exactly what I needed to know!
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 😊
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.
Short Crisp and To the Point.. Great work and Thank you so much
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
Thank you so much. This option will replace so many other steps I used to do to change the Date Format.
Thank you very much, I was changing each cell at a time, it was going to take me a lifetime lol.
Thank you.
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! Yours is the only instruction that was able to solve this for me!
Thank you! I thought I new all of this stuff and I couldn't figure out why it wasn't working! THANK YOU!
Thank you so much!! i was struggling with formatting and this made my task easy
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.
,I was doing and searching for 2hours but unable to do finally got good video it's really helpful.. thank you bro ..
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.
Oh my dear ! God bless you. Your video is quick, clear, simple. EXCELLENT... I was scratching my head big time. THANK YOU SO MUCH
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.
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
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.
Totally save a lot of my time. Been searching for this for 2 days 👍
Among all the videos, it was the best
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.
Super helpful, just saved me at least a day of headaches with some complex Excel sheets!
Thank You so much! was going insane on my file!! It is helpful & saved lot of time! :)
The amount of time you just saved me is ridiculous!!!! Thanks!!!!!!
Omg this is amazing I was struggling with this for a good 40 mins. Thank you!!!!!
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 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 for this video, my IT department couldn't figure it out, so thank you!!
wow ! That's Great to hear!
Thank you man, can't believe it's so easy to do, i've been having this question for over a month!!!! XD
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..
Excellent! Precise and very helpful!
Thank you this was exactly what I was looking for!
You just brought resolution to battle I have been fighting with Excel for the past 2 days. Thank you!!!!
Wow been trying to format sales date column all day and you helped me out :D appreciate it
OMG, thank you. You solved my problem. Couldn't figure out why cell formatting wasn't doing anything! This worked!
Thank you so much! I was struggling for more than an hour over this issue!!
thank you! this helped me big time!
Thank you!!!!!! I've been struggling the whole day before this!
Liked this video. To the point. Quick and simple.
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 god for your VDO! Really appreciate!!
Thank you very much. Really saved my time and good to know such useful tip! appreciated!
thank you so much ...after spending lot of time finally here I met with your video which saved me
Thanks for this short clip fixing this issue. Spot on. Follow this exactly and its sorted.
Man you have saved my life. 2 freaking hours!!!
Happy to help! 😊
Thank you bro. That's really a worthy video for those who work with huge data.
This was straight to the point and helpful. I left a Like. Tks.
Great video! Well done! Helped me save loads of time by this 1 minute video. You are a lifesaver lol
Great to hear!
Thank you for the great tip!
thank you! you're a genius!!
big thanks! I was struggling with this for a while. it's really helpful!
I was looking for this for very long time. Thank you!!!
Thank you so much! It was REALLY helpful!! Thanks, again.
THANK YOU!! I've been going crazy trying to figure out what was wrong! Most of my cells were fine but one particular date was doing it's own thing even though the format tool showed the same thing as the other cells :)
You're welcome!!
Thank you so much! You have me sooo much time and energy! Best of luck to you!
Thanks! Better than all of the official Microsoft guidance.
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 👍
Glad it was helpful!
You have just single handadly saved my day! Many thanks for this kind sir!
You are welcome!
Thank you so much! I really am having trouble with this. This helps a lot!
Check this out. 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 for sharing !! appreciate it 👍
Thanks bro bht easy way me bta dia 👌👌
Man that was awesome thanks for sharing. I know it is an old one but saved my nerves. Cheers :)
Thanks for your help Man!!
Great! Tutorial still relevant and well explained. Thanks
Thank you!! This is short and informative!
as always...where profi courses fail, random dude from India saves our lives... I salute you and BIIG THANKS :) :)
My pleasure
I spend 1 hour for USA format.... I was missing that "Text To Column" Step............. Thanks alot.... I shared your video with others as well...!!
Great to hear!
Thanks Bro! Will support you after I pay off the student loans I took on paying for the people who are supposed to be teaching me these things!
Hahaha 🤣
Thank you so much, man. Saved so many hours of my time.
I have 7000 lines of data with error in date where I could not use Vlookup function. Your tutorial saved my life. Thanks
Very Helpful, i finally got solution after seen your video, Thank you very much.
Superb video, didn't find any such good explanation anywhere. I was struggling with this issue.
I knew i wld find this on youtube bcoz of marvels like u..thnx boss..
OMG thank you so much!!! This saved me
I don't know how to thank you. This really helped me. 👍👍👍
Thanks the tip - awesome. I could not figure out why when I pasted as value into a date column I got date as text but when I typed it , it went in ok. While all I needed to fix the problem is what you showed med her - huge thanks from my side
Genius!! i've struggled with this for so long!!
This really helped. Thank you
Dude, freaking genius! Thank you so much!
awesome! thank you so much!
I browsed the entire internet only to find my solution here. Thank you so much!
simple, sweet and to the point video
Thank you exactly what I needed
Thank you so much...been sitting with this error for 1 hr
Nice and concise. Thanks!! 👍
Wah bhai wah gajab
You solved my problem in which got stucked for 1.5 hours thanks bro