Forum Discussion
Convert DD/MM/YYYY HH:MM to MM/DD/YYYY HH:MM
I have a spreadsheet that I am working on and the dates that have been given on the sheet are in the European format (DD/MM/YYYY HH:MM), but I need these converted to the US format (MM/DD/YYYY HH:MM)...
Here is a manual setting with cell formatting.
It works for me (Excel 2016), attached the file with the desired settings.
Format a date the way you want
Format Code in Custom:
MM/DD/YYYY HH:MM
Wish all a nice day / night with lots of health, joy and love.
Nikolino
I know I don't know anything (Socrates)
I have attempted this as well, but it still isn't reading the dates properly. It will read some, so long as the day displayed is less than 12. However with this the information is confused and European format 13/01/2019 is not recognized and 12/01/2019 is recognized as December 1, 2019 when converted to US format.
- =IF(ISNUMBER(SEARCH(“/”,A1)),DATE(RIGHT(A1,4)*1,LEFT(A1,2),MID(A1,4,2)),IF(A1=0,””,A1))
untested, should work :))