Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

2 replies

Answer 1 / 2

Hi

You can use this
=(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,13)) to convert the date format in your excel.
Thank you
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

Report

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

Hello,

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