How to Convert DD/MM/YYYY to MM/DD/YYYY [Closed]

Report
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.
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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.