Forum Discussion
sp3124
Sep 22, 2021Copper Contributor
DD/MM/YYYY HH:MM am/pm to MM/DD/YYY MM:HH
I have a date in the form of 22/09/2021 3:07 am 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. ...
JKPieterse
Sep 23, 2021Silver Contributor
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