Where is my date format coming from?
I have specified the Google Sheet:
File > Spreadsheet Settings > Locale:
I have formatted all date columns in the spreadsheet as DD/MM/YYYY.
Data > Tables > Locale:
Spanish (Spain, International Sort).
In data entry forms, all dates are masked with DD/MM/YYYY – good.
But when viewing a date in read-only mode, on my computer the date still displays as MM/DD/YYYY.
On my phone the same date correctly displays as DD/MM/YYYY.
Details of my computer:
Mac, with locale set to Spain.
Yet the dates still display in MM/DD/YYYY on the computer.
Reproduced in both Chrome and Safari.