Today I recognised an annoying problem in Excel because a workbook in Office 2016 for Mac showed the wrong date and currency formats. I always got the English date format as value. Sure I was able to change the date values to match the German format convention, but that was just for display.
![Excel showing wrong date format according to region settings](https://n8d.at/wp-content/uploads/2017/10/excel-wrong-format-1024x509-1.jpg)
Excel showing wrong date format according to region settings
Even when I entered a correct german date, then it was not recognised as such. Excel identified the value only as text.