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
Date formula in excel dd/mm/yyyy - Guide
How to convert number to words in excel - Guide
How to convert numbers into words in ms excel - Guide
Convert m3u to mp3 - Guide
Convert dts to ac3 mkvtoolnix - Guide

2 responses

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.

Similar discussions

Ig stories from close friends to public

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!