I have some locale-problems with my Excel-installation (Microsoft Office Professional Plus 2010, v14.0.xxx).

My case is as follows:

Cell A1 has the following value: "01.01.2014" (datatype is date)
Cell A2 has the following formula: "=TEXT(A1;"dd.mm.yyyy")"
Cell A2 displays: "01.01.yyyy"

My OS (Win 7 64bit) is set up using Norwegian as language/locale, and if I change the format to "dd.mm.åååå" then it will display the date correctly. However, this workbook is for international usage, and for users in UK the "dd.mm.åååå" format-string will not work.

How do I specify that my workbook is to use English (UK) as the locale for everything?

What I have tried?
1) File -> Options -> Language ->Editing Languages and Display/Help Languages are all sett to English (UK) / English
2) Ctrl + A in the worksheet to select everything -> Format cells... -> Number -> Date/Time/Special -> Locale = "English (UK)"

I have not been able to find any other references to languages. Could someone please help me with this?