I'm using an English Windows 10 with regional set to Dansih, but still Excel shows US formatting in all date/time/number formats.
I'm using an English Windows 10 with regional set to Dansih, but still Excel shows US formatting in all date/time/number formats.
Hi @Lars_Bo_Wassini ,
Thank you for reporting this.
We will look into it and let you know what we find.
Have a very nice day ahead.
Kind regards,
Marie (Danish Language Moderator)
Hi again @Lars_Bo_Wassini,
So I have received a preliminary answer from our engineering department, and they need a little more information in order to process your question:
1) Can you please confirm that after changing the language, you have restarted your computer in order for the change to take effect?
2) If restart does not work, can you please provide more information on which build version of the OS and Office you use? Can you also specifiy which language you have used during Office installation?
Thanks a lot.
Kind regards,
Marie
1) I haven't changed the language - it's been English for several years - and I reboot every day
2)
Office is in English
Thanks for all the additional information. Given your OS & Office version and language info in order to see Danish date and time formats in Excel you will need to:
1) Add the Danish language pack to Windows. See instructions on how to do that here.
2) Once you add the Danish language then you can set your regional format to Danish also.
3) Close Excel and open it again. Date, time formats should be in Danish. You might need to restart your machine also.
Hope this helps!
Staff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.