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)