Article
1 comment

How to apply your locale to Office for Mac

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

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.

[Read more]