Dates conversion

Closed
Herodia - Oct 16, 2017 at 10:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 16, 2017 at 11:25 AM
Hello,


How do i convert dd/mm/yyyy to mm/dd/yyyy for this date 05/10/2017 into 10/05/2017? this formula (MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,2))+0 is not working
thanks
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 16, 2017 at 11:25 AM
Hi Herodia,

Go to cell properties by right-clicking the date cell (or Ctrl+1). Here you can choose different date formats.

When you want to use a formula for that, then use:
=TEXT(A1,"mm/dd/yyyy")

Best regards,
Trowa