Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I currently have a data set that looks like this:
The issue for me is that it is currently stated in a format of "Month-Date-Year". I would like to replace this with a format of "Date-Month-Year".
Does anybody have a nice solution to this, for example a formula as illustrated in my photo?
Thank you all!
Kind regards,
Jyggalag
I currently have a data set that looks like this:
The issue for me is that it is currently stated in a format of "Month-Date-Year". I would like to replace this with a format of "Date-Month-Year".
Does anybody have a nice solution to this, for example a formula as illustrated in my photo?
Thank you all!

Kind regards,
Jyggalag