Previous Topic Next Topic

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
Related:

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

How to convert number into text in Excel
boratechandu -
Raj -

9 responses
how to convert Date into text.
rk gupta -
TrowaD -

1 response
date format *dd/mm/yyyy and dd/mm/yyyy
HorsemanNL -
ac3mark -

1 response
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response