Dates conversion

Closed
Herodia - 16 Oct 2017 à 10:02
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 16 Oct 2017 à 11:25
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
16 Oct 2017 à 11:25
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