Hellow guys, Welcome to my website, and you are watching Excel - Convert DD/MM/YYYY to MM/DD/YYYY Date Format in Excel - Episode 947. and this vIdeo is uploaded by MrExcel.com at 2009-02-10T10:22:48-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel - Convert DD/MM/YYYY to MM/DD/YYYY Date Format in Excel - Episode 947 |
| Video Uploader | Video From MrExcel.com |
| Upload Date | This Video Uploaded At 10-02-2009 13:22:48 |
| Video Discription | Microsoft Excel Tutorial: Convert DD/MM/YYYY to MM/DD/YYYY Date Format in Excel Welcome back to the MrExcel netcast! In today's episode, we're tackling a common issue that many Excel users face - wrong date formats. We all know how important it is to have accurate and usable data, but what do you do when you receive a CSV file with dates in the wrong format? Whether it's day-month-year or month-day-year, it can be a real headache to work with. But fear not, because I'm here to show you a quick and easy solution. So, let's say you receive a CSV file from a colleague in another country, and the dates are in the wrong format for your location. For me, being in the United States, the wrong format would be day-month-year. But if you're somewhere else, just imagine it's reversed. When we open the file in Excel, we see that the dates are not recognized as real dates. This means we can't format them or use them in calculations. So what's the solution? Well, some may suggest changing your international settings before opening the file, but I believe there's a faster and more efficient way. Simply go to your "Windows Explorer" and find the CSV file. Then, rename it to a text file. When we open a text file in Excel, it takes us through a wizard where we can declare the date format in step 3. Here, we can specify that our dates are in day-month-year format and voila! The dates are now imported correctly. This little trick is a lifesaver when dealing with wrong date formats in CSV files. And the best part is, you don't have to change your international settings. Just remember to change the file to a text file before opening it in Excel. I hope this tip helps you save time and frustration in your data analysis. Thanks for tuning in to the MrExcel netcast, and we'll see you next time for more helpful tips and tricks. Don't forget to hit that like button and subscribe for more Excel content. Until next time, happy Excel-ing! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Introduction to MrExcel netcast (00:10) Problem with CSV files and dates in wrong format (00:30) Solution: Opening CSV file as a text file in Excel (01:53) Using the wizard to declare date format (02:17) Conclusion and thanks for watching #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Changing international settings in Excel for date formats Efficient solution for importing and formatting dates in Excel How to format CSV files with dates in different formats How to rename a file to a text file in Windows Explorer Importing and formatting dates in Excel without changing international settings Importing CSV files correctly in Excel MrExcel netcast episode on resolving date format problems Resolving default date format issues in Excel Solving date format issues in CSV files Tips for importing and working with CSV files in Excel Using Excel's text file wizard to import data with specific date format YouTube video on analyzing data and using pivot tables Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152153/ You get a CSV file from an International branch of your company and the dates are in M/D/Y when you use D/M/Y or vice versa. There is an easy solution. Episode 947 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! |
| Category | Education |
| Tags | accounting | business | csv | dates | excel | international | mrexcel | spreadsheets | technology | tutorial | Excel | MrExcel | Formula | Bill Jelen | Learn Excel | Excel Tutorial | Power Excel | Microsoft Excel | Excel Tips | Data Set | Excel Help | Learn Excel with MrExcel | Excel Tips and Tricks | MrExcel Podcast | mrexcel channel | mrexcel website | mrexcel forum | excel guru | mrexcel tips and triks |
