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. I tried changing the format of the date but it is not working. Any help would be very helpful.
5 Replies
- JKPieterseSilver ContributorYou 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
- sp3124Copper ContributorHey Jan, the data was pulled into excel from database but it came with that date structure.
- JKPieterseSilver ContributorWhich version of Excel are you using and how exactly did you do the import (which item in the menu)?