ERRORS data import -- "must in dd/mm/yyyy format" (but my system is mm-dd-yyyy)

This is my system setting for date:
image

This is my import error:

I got it to import, but it’s very tricky/buggy…

in excel I had to change everything to:

YYYY-MM-DD

(even though this wasn’t the format of the example template downloaded from erpnext data import)

I then had to set the format cells in excel to YYYY-MM-DD:

image

I uploaded and no more errors, but now my list view looks like:

image

and form entry looks like:

image

oh well. It’s working I guess.