Forum Discussion
Convert DD/MM/YYYY HH:MM to MM/DD/YYYY HH:MM
mindlessmama How exactly were these dates imported? You mentioned that the CSV file contains dates in the European style. Then it's important that you indicate upon import that these are European dates. In Text-to-columns (TTC), for instance, you must indicate in Step 3 of 3 that these are dates "DMY". Now Excel will transform the dates to your system locale and you can choose whatever formatting you want and the time portions are preserved.
I repeated the TTC steps described above and could transform the list of dates to what you find in the attached workbook.
Riny_van_EekelenSo i retried this and during the import listed all of the DD/MM/YYYY HH:MM as DMY, but it still isn't recognized as such upon the import. I tried to reformat the fields after the import as dd/mm/yyyy hh:mm under custom, but it only adds leading zeros. It still will not show me the date as MM/DD/YYYY HH:MM as I need it to. Any ideas on how to break the date and time into separate cells? I'd gladly change the date after it is separated.