Forum Discussion
Sam99615
Feb 18, 2022Copper Contributor
Help changing: DD-MM-YYYY HH:MM to YYYY-MM-DD HH:MM
Hi, I am struggling with changing date formate in Excel form DD-MM-YYYY HH:MM to YYYY-MM-DD HH:MM I have tired to custom change with formate but it does not work. I looked online and fou...
HansVogelaar
Feb 18, 2022MVP
The formula bar always shows the date and time according to your computer's system settings.
The values in column A look like text values. Try this in B2:
=MID(A2,7,4)&"-"&MID(A2,4,2)&"-"&LEFT(A2,2)&MID(A2,11,6)
Fill down.