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

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

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

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

I’ve never commented on any RU-vid 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!

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!! A life saver, I was going crazy without being able to format the date to a value I can use filters on!!

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.

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

I have struggled with this for years and really appreciate this video. It fixed it in less than a minute. 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!

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

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..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 😊

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

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?

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 ..

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

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

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

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.

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

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

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

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.

Thanks bro bht easy way me bta dia 👌👌

Thank you so much...been sitting with this error for 1 hr

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

just saved an hour of my life thank you.

Man you have saved my life. 2 freaking hours!!!

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

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

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

Among all the videos, it was the best

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

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

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

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

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

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

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

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

I have a date in excel displaying as 201903 when I want to format it I select format cell- custom- YYYYMM it formulates the date as 245210 , then I try and calculate the month with a formula =Month(cell) I get 10 as the displayed month and it should be 03 and when I put the formula for the year =year(cell) I get 2452 . How do I get the correct value displayed?

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

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

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

I have 7000 lines of data with error in date where I could not use Vlookup function. Your tutorial saved my life. Thanks

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

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

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

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

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

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

Thank you, I don't comment a lot, but this seriously helped 😊😊

I don't know how to thank you. This really helped me. 👍👍👍

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

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!

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.

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

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

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

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

as always...where profi courses fail, random dude from India saves our lives... I salute you and BIIG THANKS :) :)

In VBA Excel 2007 I typed date as 9-01-2020 but in the sheet it shows as 01-09-2020 (Windows 10). I tried more than 3 days, no success. How to go ahead, please?

Thank you this was exactly what I was looking for!

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

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

Hi, may i ask how can i format this: 2019-04-05T00:00:00 to normal Y,M,D ? thank you

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

OMG i was struggling for this problem today the whole day! and i searched for other videos but it doesnt work. thxxxxx for teaching me!

Thanks! Better than all of the official Microsoft guidance.

Can you do the same with time values. Im having trouble changing the PM values to time format

sir i have one doubt while i use auto fill date does not changing other than date year are changing

Superb video, didn't find any such good explanation anywhere. I was struggling with this issue.

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

THANK YOU VERY MUCH. CUSTOM NOT WORKED BUT TEXT TO COLUMNS WORKED

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...!!

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

Brooo you don't know how many hours combine you saved people !1 That's crazy, thank you !

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

I browsed the entire internet only to find my solution here. Thank you so much!

Bro, From my head was coming smoke bcz fixing problem, but you saved my time , thanks

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

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

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

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

hi, just wanted to let u know that im spending hours n hours to figure it out myself why on earth it cannot be formatted all together until i met this videooooo. its 4am now. hahaha i need a sleepppp but still lot of work need to be done. thanks

Hi I want to conver this time date format to only date like 12-Jul-2020 20.30PM I want to have only 12-Jul from above How I can do that? Please suggest

Okay so my problem is that i have an excel with dates and a word with mail merge activated with my excel. Whenever i try to pull out the dates on my excel, it grabs them like this 12/9/2018. On the excel the date format is December 9, 2018 but it still changes on the word. Any idea on how ti solve this issue?

Excellent! Precise and very helpful!

superb trick. never thought this was possible in a few seconds.

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

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

Can u plz tell how to change 1122018 to date dd-mm-yyyy. I tried lot of logics, but in vain. Is there any formula to reverse the text?

You saved my life.. I was like what I am doing !! Arghhhhh! but thanks to you. You are great 👍👍

Thank you so much! I really am having trouble with this. This helps a lot!

Great! Tutorial still relevant and well explained. Thanks