How to make a Cell in Excel behave like a Date Field.

Did you intend to keep it as a CSV file? In CSV files, there's no Date field option, as it's plain text. If you keep it in CSV, the program has to have the logic for properly reading the date.
If you want it in Excel, do this formatting only once (and obviously, save it in Excel format):



Or if you really want it as CSV (because the import app only accepts that), try setting it to this format (yyyy-mm-dd), and save it back to CSV:

PLATE_ID,REPORT_DATE,REPORT_HOUR,AMOUNT
3685,2020-10-31,0,0.034
3685,2020-10-31,1,0.034
3685,2020-10-31,2,0.032
3685,2020-10-31,3,0.031
3685,2020-10-31,4,0.031

And then hope the import is smart enough to know this is really a date.

Resolved