I had an issue with Microsoft Excel 2010 (well not exact an Excel issue, but anyway). When a end-user tried to use this formula “=TEXT(DATE(2012,2,20),”dd.mm.yyyy”) “ It end up like this:
This is likely an language issue, because we likely have some Norwegian settings. If we try “=TEXT(DATE(2012,2,20),”dd.mm.åååå”) “ it ends up like.
Okay, so now we know it is language setting. I confirmed “format cells” setting in Excel
When I checked Windows regional settings I was surprised that regional settings was set to English UK, and date format dd.MM.yyyy. I also know that installation language on Windows and Office is English.
I tried to change the “Region and Language” format manuallyto Norway and back to English.
Guess what the result was? In Excel the Formula now worked and Format Cells showed
I checked Group Policy, and found that Group Policy preferences sets and Regional settings to English UK for all users.
This works very well, but the interesting part is that I checked and compared registry path HKEY_CURRENT_USERControl PanelInternational between each step. See the results below:
When regional is set by Group Policy Preferences: When regional is set manually
You see the difference? LocaleName is set to en-GB in both cases, but sCountry, SLanguage and iCountry is different. So I found that when Group Policy preference sets the Regional Setting, sCountry, SLanguage and iCountry registry are not set to the country you set. I tested to edit this keys manually, and found out that Excel uses iCountry to choose formatting cells.
I guess this is a Group Policy bug?
I have confirmed that this NOT is a BUG. http://msdn.microsoft.com/en-us/library/cc980066(prot.20).aspx But it would anyway be nice if all registry keys was updated:)
And I also get comments on how I addressed this issue: Simply by creating a Group Policy Registry items populating iCountry, sCountry and SLanguage.