I received an Excel file with a column filled with slash-separated dates in a given column.
The dates isn't directly recognized by Excel as being so. Thus, it is not sorted correctly when I use the sort tool. I am able to turn this cell into date format by going into it, hit F2 to edit, then just Enter. But this is too long because my file have hundreds of lines...
I saw here I could use a formula in a collated cell to do the job.
I'm looking for the most efficient way to turn this column into a date format, that would avoid using vba, if there is any other as the above.
Edit: I'd rather avoid changing my PC's behavior, so I'd also prefer not to change the locale like advised there of the whole system. Maybe changing it only for a workbook could work? But how?