TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello,
I have inherited a file which has a mixture of US and UK dates - the locale of this system is UK.
So I have data like 31/03/2020 but also 2/28/2020. The US dates are aligned to the left and the UK ones to the right.
How do I fix? I've read about text to columns, formatting the cells and stuff like that but none of it works.
I have inherited a file which has a mixture of US and UK dates - the locale of this system is UK.
So I have data like 31/03/2020 but also 2/28/2020. The US dates are aligned to the left and the UK ones to the right.
How do I fix? I've read about text to columns, formatting the cells and stuff like that but none of it works.