I have a spreadsheet which was generated by a powershell script. For some reason it has formatted some of the dates as General and some as Custom. I need them all formatted as dates.
All the fields contain text similar to this:
I want to be able to sort the sheet by dates. I'm not too concerned about the time part of the data which could be removed if that helps.