How change date format in excel (dd/mm/yyyy) to (mm/dd/yyyy). How to fix date format issue in excel.
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- Convert US Date formats to INDIAN format.
If you learned something new and found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover next.
In this video you learn how to change date format
How to change date formats in excel as per your country location
Date format problem in hindi
Date format problem fixed
How to date format change in excel and power query
How To Change the Date format to DD MM YYYY in excel As you can see we have data format in MM DD YYYY which is United States format.
In some scenarios you will not be able to change date format in excel because the date will be formatted in text.
Highlights
1. How to write date in excel
2. How to correct date format using locale
3. How to upload csv file in power query
4. Indian number format
5. United States number format
6. How to use text to column in excel
7. Excel advance and power bi for beginners
8. How to change date type in power query
9. Data cleaning in power query
10. Power Query Editor
11. India date format and US date format
12. Data cleaning in excel
13. How to use query setting window
United Kingdom Date format, Australia United Kingdom Date format, Canada United Kingdom Date format,
Caribbean United Kingdom Date format, Hong Kong United Kingdom Date format, India United Kingdom Date format,
Indonesia United Kingdom Date format, Ireland United Kingdom Date format, Singapore United Kingdom Date format,
United States United Kingdom Date format, excel advanced function in hindi and english, power query m code function, excel and power query together, made for beginner, power query editor user interface, power query editor graphical interface, how write use text to column, date format kese sahi karein, data cleaning in excel, data cleaning in power query
#Dateformatproblem #PowerQueryTrick #ExcelPowerQuery #ExtractNumber #exceltips #exceltricks #Averageclassmate #Texttocolumn #Dateformatissue
For Excel tips and tricks to improve productivity.
Watch Our Learning Videos:
---------------------------------------------------------------------
Mastering Power BI: How to Build Interactive Dashboards for Data Visualization | Dynamic Dashboard 2
• Mastering Power BI: Ho...
---------------------------------------------------------------------
Master DAX in Power BI: A Comprehensive Tutorial | Maximize your Power Bi analytics with DAX
• Master DAX in Power BI...
---------------------------------------------------------------------
Mastering Power BI: How to Build Interactive Dashboards for Data Visualization | Dynamic Dashboard Part 1
• Mastering Power BI: Ho...
---------------------------------------------------------------------
Unlock Your Potential: Discover the Power of Positive Thinking and achieve Your Dreams
• Unlock Your Potential:...
---------------------------------------------------------------------
VBA is no more scary. It is so simple to use with best practice. Interview question solved easily
• VBA is no more scary. ...
---------------------------------------------------------------------
DAX and Power Query and Best practice. Dax Functions and Limitation
• DAX and Power Query an...
---------------------------------------------------------------------
How to create simple and insightful Excel Dashboard. Power BI Dashboard banane ka sahi tarika.
• How to create simple a...
---------------------------------------------------------------------
How to create simple and insightful Dashboard : Excel and Power BI:
• How to create simple a...
---------------------------------------------------------------------
Power BI practical interview questions & answer. How to crack PowerBI interview?
• Power BI practical int...
---------------------------------------------------------------------
Different Header consolidate best practice | Fastest method to consolidate unstructured data.
• Different Header conso...
---------------------------------------------------------------------
Top 5 mostly asked VBA interview Questions in 2023. Crack VBA Interview.
• Top 5 mostly asked VBA...
---------------------------------------------------------------------
Multi Level Filter in seconds | Real short cut for filter data
• Multi Level Filter in ...
---------------------------------------------------------------------
Excel tips and tricks to improve productivity. Tips and tricks to be productive in office
• Excel tips and tricks ...
---------------------------------------------------------------------
⚡ You can reach out to us, anytime ⚡
![[TH] 2024 PMSL SEA W2D5 | Fall | พลาดวันนี้ จะต้องเสียใจ](http://i.ytimg.com/vi/A5-Cuo12p6A/mqdefault.jpg)
this video really works thank you sir
Thank you for solving . It was indeed happy learning
You're very welcome! I'm glad you found the video helpful and enjoyed the learning experience. 😊 Happy learning
Friend when I am writing this comment it's 01:20 AM (mid night) I was finding solution madly & thanks god I landed on this video, & boom you solved my big problem, now I will sleep peacefully, thank you Bro keep helping, you are doing a big job, thank you, thank you, thank you
Thank you so much for your heartfelt comment! I'm truly glad that my video could help you find the solution you were looking for, especially at such a late hour. Knowing that I could assist you means a lot to me. Your kind words and support are incredibly motivating. By far one of the best comment, I got for my works. 💖 se dhanyawad (Thank you so much).
@@AnalyticsInDetails keep helping us forever ❤
I watched 2 3 videos all of them using Custom formula and was not able to solve it...but using this way it was only 2 sec work👍you saved my time thank you
Thank you sooo.. much for taking time and writing a positive comment. I'm thrilled to hear that my video was able to help you solve the date format issue quickly. Happy to help! 💕
I love it you just save me I was working overnight and couldn't solve this problem
God bless you
I love it
I am glad to know that it helped you. Keep learning and keep growing. 🙂Thanks for your blessing.
Thank you very much for helping me out of my sleepless nights trying to reset the date in a dataset. 👌👌
You're very welcome! I'm thrilled I could assist you in resolving the date reset challenge. If you ever have more questions or run into any issues, feel free to reach out. Sweet dreams and happy data handling! 👌😊
Thanks a lot sir. I've watched lots of videos about this date problem but all of them were unable to solve my problem. Your video has solved my problem.
Awesome😊, thanks a lot for taking time to write a positive comment 🙏 I am glad I could help you.
Hey, I just wanted to big thank you for this video, it literally saved me from going crazy. To my Project, It was reversed from US to India Zone however, Would you please consider making one video over Data Cleaning collected from multiple time zones. It might help people understanding complex data with Date format. Kudos.
Thank you so much ☺️ for taking time and writing this beautiful comment. I would certainly think to create a video to solve this complex date format problems.
Thank you very much, it helped me alot then other videos
This video saved me after one week of stress and headache.
Thank you❤❤
Thank you for your kind words! I'm delighted to hear that the video was helpful for you. If you have any more questions or need further assistance, please don't hesitate to reach out. Stay stress-free!
Live saver 😊
Thanks for sharing this video. I had same problem and this video helped right at once. Keep sharing your knowledge.
Awesome, Thank you 🙏 for the positive comment. I am glad that you found this video useful. Stay connected for more useful content.
Awesome, was struggling with this for long time, u hv made life easy. Thanks brother. Lots of love n blessings to u
Thank you for taking the time to watch my video and leaving such a positive comment! I'm glad to hear that it helped you with whatever you were struggling with. It's always a great feeling to know that I was able to make a positive impact in someone's life. Your kind words and blessings mean a lot to me, and I appreciate them greatly. Wishing you all the best and sending lots of love and blessings your way too!
It is confusing
@@TheDataScientist007 🤣🤣 Only for few but for many people it is a solution. Keep watching you will get the answer. Trust me you are very close.
Thank you so much, this is the video I've been looking for!🤧
You saved my so many hours....Thanks!!!!😄😄😄
You're most welcome. I am glad that I could do that. Thanks a lot for taking time to write a positive comment.😊
Thank you so much struggling hard but this video solved me you are the hero
I'm genuinely touched by your words! Keep pushing forward, and know that you've got a support system here. Cheers to your success!
Superb.. I learnt new thing today .
Thank you so much! I'm thrilled to hear that you found value and learned something new. Stay connect and Happy learning.
At 10:55 Column C is already alligned with mm/dd/yy format..later u applied MDM condition then how it will again revert back to DMY 31-07-2012?
Trust me, you're very close to understanding how Microsoft Excel works! Keep downloading the file and experimenting with it yourself-hands-on practice is the best way to learn. This video has helped many people, as you can see from the comments. Keep going, you're on the right track! 😊
Im not indian but i managed to follow up and completed my project. Thanks😂
Wow, kudos to you for successfully completing your project, regardless of your nationality! It's always inspiring to see people from different backgrounds come together and achieve their goals. Remember, talent and determination know no boundaries! 🌟
Keep up the great work, and may your future endeavors be just as successful. Cheers to embracing diversity and celebrating accomplishments together! 🎉
You are soo amazing sir... thank you soooooo much 😊😊😊😊😊
Thank you from the bottom of my heart for your incredibly kind words! Your support means the world to me, and I'm thrilled to know that you find value in the content. If there's anything specific you'd like to see or learn more about, feel free to let me know. Keep shining, and thank you for being a part of our community! 😊
@@AnalyticsInDetails thank you..
I struggled this video helped me 🎉
I'm so glad to hear that this video was helpful to you! It's amazing how the right resources can make a big difference when we're facing challenges. Remember, we all stumble and struggle sometimes, but it's how we rise and learn from those experiences that truly counts. 🙌
I hope you found the guidance and support you needed through this video, and I encourage you to keep pushing forward with determination and a positive mindset. You've got this! 🎉
Stay connected and Happy learning.
Thanks sir
You're most welcome ji.
Very useful . Excel date problem solved
Thank you
Glad I could help! Let me know if there's any other topic you are interested in.
@@sowmiyaveni8484 You're welcome! Let me know if there's anything else I can help with.
Will try this...thank you 🙏
You're very welcome! 🙏
Thank you Bhai, this is very useful ☺️
That's great 👍 Glad to know that you found it useful.
U have solved my issue. Very thankful
Happy to help you.
dear sir jab aapne excel me date ka format change kiya toh sahi date v wrong ho gyi... jaise jo phle se 02-05-2020 tha ye toh correct tha but aapke change krte hi ye 05-02-2020 ho gyi it is wrong na
Normal new user ko Aisa hi lagta hai at first glance not your fault. But watch the video properly and do it yourself, you will get the right answer only. Happy learning.
Thank you so much. This video proved useful. However, how do I get your other videos? I need to know how to handle missing dates in excel
I am glad to help you all. To handle missing dates in excel you can watch this video:
th-cam.com/video/mWirDLfhevE/w-d-xo.html
This literally helps me alot..
I'm so glad to hear that the content is proving helpful for you! Your feedback fuels the channel, and I'm here to provide content that makes a positive impact. Keep rocking and learning! 🚀
Good work.... keep it up 👍
Thank you so much for your kind words and encouragement! I really appreciate it and it means a lot to me. I'll do my best to continue creating content that you enjoy and find valuable. Thanks again for taking the time to watch and leave a comment!😊
You're very welcome! 🙏
it work on my pc thx bro vеry much
Nice to know that.
Thank you so much!
You're welcome! It's always great to hear that I was able to help or provide value in some way. If you have any other questions or feedback, feel free to let me know.
You are awesome
Thank you so much for taking time to write a positive comment. Your kind words mean the world to me. I'm truly grateful for your support.
Kr di bhai
Like
Thanks for the support! I appreciate you taking the time to write this comment and show your appreciation. Keep enjoying the content.
Thank you so much.
Most welcome.
Thank you❤
You're very welcome! ❤Happy to have you here! 😊🎉
Thank you mate.
Your welcome.
HI Why i follow the same steps. dew are getting showing error. how to do that
Thank you sir
Glad you like the work and you got the solution. Happy learning.
Very useful
Thank you.
You got a subscriber...:)
Awesome 💯😎 thanks a lot.
GRAET SIR
Thank you so much for your kind words! I'm glad to hear that you find the content helpful.
thank you
Most welcome. Stay connected and happy learning.👍
How to change feb 11 2011 date to 11-02-2011 in excel?
thz!
Always welcome.
I could not change even after following the step
Keep trying you must be missing 1 step. People use these tricks on a daily basis. Best of luck.
How to add a suffix like st, nd, rd & th in date format?
When I did that I got error in power query :( , what kind off data did I receive :(
NO Dear this solution will not work let take two date in same column in first cell Mention 01/05/2023 and in next 31/05/2023 and your system date is in US format then it will consider 01/05/2023 as correct date and change it to 5-Jan-2023 and second would be 31-May-2023, and we know that both dates are in same month
Request you to watch this video properly and you will get this resolved surely. Don't skip the video.🥳👍
@@AnalyticsInDetails I have watched carefully it wouldn't work
Which solution are you searching Excel or Power query?
@@storieswithtarasharma2914 if you know the correct answer pls do let me know..
What you said is right... this video is incorrect... facing the same issue like you said.
Dear, sir may you write me the format or the process of how to change and correct the date format in Excel
Must watch complete video. You will find the way.
How to convert it in SQL?
Last one is changed dmy and you have selected mdy
Yes, that is trick or need to know which format to be selected. Lots of people get confused here.
Let me make it simple, we need to select that date format which we need to correct, that's it. Therefore, as per US date format, data was showing incorrect in my report, so I select Column data format "MDY". Hope it answer your question. If not, then highly suggest rewinding the video and only watch Timeline 11:00 to 11:15 in 15 seconds., you will get your answer. Don't forget to reply. ALL THE BEST👍
Perez David Jones Jeffrey Williams Lisa
Lopez Gary White George Rodriguez Nancy
There are some problems when you change date format in excel...
Let take first two rows
Before changes
1st row (7/31/2012)
2nd row(02-05-2013 or 02 may 2013)
But after changes
1st row ( 31-07-2012)
2nd row(05-02-2013)
Here 2nd row also changed wrongly
Check this
If you have a large number of dates to change, you can use Excel's Text to Columns feature to convert the dates to the correct format. Use the method which I mentioned in this video. When you increase width of that date column then dates matching your system region setting, that would get auto corrected and aligned right side. Means you would only have left align date which needs to be corrected. Either it would start from month or day, it doesn't matter as Data format which we select in Text to column wizard would take care that. Please watch video again and follow the method shown in video. Indeed, It would give correct result. Hope it was helpful. Enjoy watching and happy learning.👍👍
What you said is right... this video is not correct. Please look into it properly and provide a correct solution