I'm trying to import a CSV file whose first column contains dates in mm/dd/yy format, e.g. "4/28/18". You'd think it would be simple...
When I use the new Excel 2016 Data -> Get Data -> From Text/CSV function and use the Edit option, I can select Date, but I have no control over the format. It tries to interpret them as YYYY-MM-DD, and of course that produces junk.
It may be that this problem wasn't an issue with previous versions of Excel (where you could define custom date formats), but the old Text Import Wizard had been replaced and no longer appears to be available.
Surely there must be _some_ way to tell Excel what date format to use when importing!