Windows 10, Date formats and Excel

Since installing Windows 10 I noticed that the date formatting in my Excel spreadsheets had become inconsistent. It turns out that even though I had selected my location as UK and my keyboard layout as British, the system still had the system locale and associated settings as U.S.

Something to watch out for...