|Dates||Text to Columns||Text to Columns||Text to Columns||Search "/"|
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?