Switch Position of Number

[wayneho98]

lets say my date was 18-09-2024 (dd-mm-yyyy)
i need a formula that can change to 09-18-2024 (mm-dd-yyyy)
is that possible?

thanks in advances!

 

[Cubist]

1) Select range
2) Data Tab -> Text to Column
3) Delimited -> Next
4) Uncheck all of the Delimiter Selections -> Next
5) Date -> "DMY"
6) Finish

 

[Rick Rothstein]

For the formula solution you asked for...

=TEXTJOIN("-",,CHOOSECOLS(TEXTSPLIT(A1,"-"),2,1,3))