Dates conversion [Closed]

Report
-
Posts
2717
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 1, 2021
-
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

1 reply

Posts
2717
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 1, 2021
459
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!