Dates | Text to Columns | Text to Columns | Text to Columns | Search "/" | ||||
23/11/2018 | 23 | 11 | 2018 | 3 | ||||
1/3/2019 | 1/1/1900 | 3 | 2019 |
<tbody> </tbody> | ||||
31/03/2019 | 31 | 3 | 2019 | 3 | ||||
1/11/2018 | 1/1/1900 | 11 | 2018 | #VALUE! | ||||
24/10/2018 | 24 | 10 | 2018 | 3 | ||||
<tbody>
</tbody>
The first column above shows the dates I have. I've tried changing them from dd/mm to mm/dd but it doesn't seem to be responding properly.
As one example I tried going to Text to Columns so that I could separate it into individual parts. Didn't work out too well. I later used the front-slash as the separator but the results were weird. You can see the results in columns B-E above. I've bolded/underlined the cells not behaving properly.
Can anyone advise what's going on?