DD/MM/YYYY HH:MM am/pm to MM/DD/YYY MM:HH

Question

I have a date in the form of&nbsp;22/09/2021 3:07 am&nbsp;This was exported from a database and is stored in text format. I want to change the format such that I can view this as 09/22/2021 03:07. I tried changing the format of the date but it is not working. Any help would be very helpful.&nbsp;

jkpieterse · Answer

You say exported from a database, why don't you pull the data directly into Excel from that same database? That will give you more control over the format of each column. See: https://support.microsoft.com/en-gb/office/import-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a

sp3124 · Answer

Hey Jan, the data was pulled into excel from database but it came with that date structure.

jkpieterse · Answer

Which version of Excel are you using and how exactly did you do the import (which item in the menu)?

sp3124 · Answer

I am using recent version of office 365.In the database , when I give a time filter to retrieve data and hit export , a csv file is automatically downloaded .

jkpieterse · Answer

Then do not open the CSV by a double-click in Explorer, but rather open Excel and use Data, From Text/CSV to open the file using PowerQuery. Then you can set the date and time format to your liking. After setting things up you can next time simply refresh the date when a new export is made.

Forum Discussion

DD/MM/YYYY HH:MM am/pm to MM/DD/YYY MM:HH

5 Replies