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

How to convert yyyymmdd to mm/dd/yyyy in excel
Dd-mm-yyyy format in excel - Guide
Youtube to mp3con converter - Download - Music downloads
Convert number to words in excel - Guide
How to change date format from yyyymmdd to mm/dd/yy in Excel? ✓ - Excel Forum
Convert m3u to mp3 - Guide

2 replies

Answer 1 / 2

Ramesh
Dec 1, 2014 at 07:17 AM

Hi

You can use this
=(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,13)) to convert the date format in your excel.

Cathy
Jan 7, 2015 at 02:16 AM

Thanks. The formula should be =(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,4))

Answer 2 / 2

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.

Subscribe To Our Newsletter!