How to Convert DD/MM/YYYY to MM/DD/YYYY

Closed
nsriniv Posts 1 Registration date Wednesday September 10, 2014 Status Member Last seen September 10, 2014 - Sep 10, 2014 at 04:38 AM
 Cathy - Jan 7, 2015 at 02:16 AM
Hi All,

Kindly help to convert DD/MM/YYYY to MM/DD/YYYY for the following examples.
Thanks in advance,

19/08/2014
13/08/2014
13/08/2014
4/08/2014
8/08/2014
27/08/2014

2 replies

Hi

You can use this
=(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,13)) to convert the date format in your excel.
2
Thanks. The formula should be =(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,4))
0
Blocked Profile
Sep 10, 2014 at 06:03 AM
Hello,

within Excel you need to go to conditional formatting and from there you can change the format of the date.
1