I have an Excel file with a date column. The first few entries look like this:
I'd like to adjust the date format because the current format is not usable for an application I have in mind in QGIS, a geographic information system. The following link contains information on how to adjust date formats in Excel. Upon following the instructions therein, however, I noticed that Excel does not seem to recognize the correct date of the sample. Here's what I see when I press Cmd+1, go to the Number panel, and to the Date category:
For example, the fourth preview type should read
Question: how can I make Excel read in the correct date, and adjust it to another format?