Forum Discussion
SharePoint Regional and Language settings for all sites.
How as global admin or SharePoint Admin do you change the language and regional settings for all Existing SharePoint Online sites and so that new ones have the required setting. We want en-GB.
If this has to be done through a powershell connected script where MFA is enabled I need a script that will run for each site at example contosa.sharepoint.com
Thanks
- Bright-twist11Copper Contributor
Hi LondonJim
I'm linking my post here in case its related. Apologies if it's not.
https://techcommunity.microsoft.com/discussions/SharePoint_General/default-proofing-language/4349815
- MartinLaplanteIron Contributor
There are several things here, but first the bad news: there is no way to change the site language setting after the site has been created, and en-gb is not a supported language. You can choose that setting, but you'll still get en-US.
On to better news. The site's base language and the site region setting are only defaults, they are used when the user doesn't have a setting. The user's language setting is in their M365 profile. If that is not set it will use the browser language. Provided that the site supports the users language setting, and most sites have at least basic support for all 50 languages unless you remove them, the user will see the site's UI in that language.
Region settings are a bit different. Region only affects date and numeric format. En(GB and en-US differ only in date format. Again, the user profile can override the site default setting, but only if you check the override setting.
What can you do as an admin? If you don't want anyone to see the site UI in any language other than English (en-US) then you can delete all the other languages in the site's language settings in the advanced settings. If you want users to have a choice, then you can provide their initial settings in their profile using AAD, which syncs with their profile.
- LondonJimCopper Contributor
Hi Martin, Thank you for your reply. In this case we need the Language and Region settings as dates in files esp. spreadsheet need to appear in the GB format. Seen as the sites are already created would it be best to change their profiles to use en-GB language and region format. Most of our users have already changed their language and region to en-GB but as site set up with default US settings I could only view the correct UK date format by changing the site region to UK. So the profile region was not over-riding the site region.
Are you saying the best way to do this would be to make a configuration policy for Edge to use GB region in the browser? That will be another question on how to do that as well as force that for Chrome users.
Have set the configuration so that the Office Desktop Apps show in the correct date and language when viewed there it is just the browser view that is causing the issue.