Related:
- How to convert yyyymmdd to mm/dd/yyyy in excel
- Yyyymmdd to mm/dd/yyyy - Best answers
- Convert date from yyyymmdd to mm/dd/yyyy in excel - Best answers
- How to change date format from yyyymmdd to mm/dd/yy in Excel? ✓ - Forum - Excel
- How do i convert yyyymmdd to mm/dd/yyyy in excel? ✓ - Forum - Excel
- Change yyyymmdd format to mm/dd/yy in excel - Forum - Excel
- Convert mm/dd/yyyy to mm/yy in excel 2007 - Forum - Excel
- How do i convert date to mm/dd/yyyy in excel? - How-To - Excel
2 replies
Ramesh
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.
Cathy
Thanks. The formula should be =(MID(L2,4,2)&"/"&LEFT(L2,2)&"/"&RIGHT(L2,4))
Blocked Profile
Hello,
within Excel you need to go to conditional formatting and from there you can change the format of the date.
within Excel you need to go to conditional formatting and from there you can change the format of the date.
