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
Cathy - Jan 7, 2015 at 02:16 AM
Related:
- How to convert yyyymmdd to mm/dd/yyyy in excel
- Date formula in excel dd/mm/yyyy - Guide
- Convert number to words in excel - Guide
- Convert m3u to mp3 - Guide
- How to convert number to words in word - Guide
- Convert picture to shape powerpoint - Guide
2 responses
Hi
You can use this
=(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,13)) to convert the date format in your excel.
You can use this
=(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,13)) to convert the date format in your excel.
Jan 7, 2015 at 02:16 AM