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

Closed
Posts
1
Registration date
Wednesday September 10, 2014
Status
Member
Last seen
September 10, 2014
-
 Cathy -
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.
Thanks. The formula should be =(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,4))

Hello,

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