I have a bunch of cells (coming from a CSV file) containing text like:
Dec 29, 2018
Dec 30, 2018
I have already applied the desired format to these cells, so that they are displayed like this:
Problem: Excel does not automatically recognize the dates / apply the date format. I need to do F2 then Enter on each cell for it to be displayed as I want.
How can I automatically force Excel to apply the format on the whole range of cells ? (I hope there's a smarter way than a macro...)