Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
I have a range of dates that are not being treated as dates. I have used the format cells function and changed to UK format (DD/MM/YYYY). I have also used text to columns function.
Does anyone have any recommendations on how I can convert to dates? I have included some examples below. I can't figure why these wouldn't be treated as dates
Does anyone have any recommendations on how I can convert to dates? I have included some examples below. I can't figure why these wouldn't be treated as dates
DATE_APPOINTED |
14/03/2012 |
18/12/2018 |
19/08/2019 |