CacheMeOutside

Thanks for posting this Iain, look like a good opportunity. One thing that might put some people off though is losing 3 members of the IT team in November. Are you able to share a bit more context around that for anyone considering applying?

Are you guys using Lightspeed by any chance?

This has been on my list to take a deep dive on for some time, and was hoping your post would garner a simple fix from someone in the know. Everyone's favourite AI Chatbot came back with the following: Ahh yes — that one’s been catching a lot of people lately. You’re right: even if the Windows region, browser locale, and M365 tenant settings are all UK, Office on the web (Word/Excel/PowerPoint Online) often defaults back to US locale. It’s confusing because different parts of Microsoft 365 respect different locale settings. Here’s the breakdown: 🔎 Why it happens Office apps (Word/Excel Online) don’t always use the tenant or site collection locale. They usually take the user’s personal M365 account language & regional settings. If those aren’t set, they fall back to en-US by default. So you can set the PC, Edge, Chrome, even SharePoint site to UK — but the Office apps can still decide “nah, US” if the user profile hasn’t been overridden. ✅ Fixes / Things to Try 1. Change the user’s Microsoft 365 profile regional settings Go to: https://myaccount.microsoft.com/settingsandprivacy Select Language and region Set: Display language = English (United Kingdom) Regional format = English (United Kingdom) Time zone = London/Dublin This directly influences Word/Excel/Outlook Web App regional defaults. 2. Outlook Web App regional settings (still used by some services) Open Outlook Web Gear ⚙ → View all Outlook settings General → Language and time Set to UK. Even if Outlook works fine, this change still feeds into the Office web apps for some users. 3. SharePoint (site-level vs personal OneDrive) You already checked the tenant’s site collection settings, which is good. But note: Each user’s OneDrive (personal SharePoint site) has its own locale too. URL format: https://<tenant>-my.sharepoint.com/_layouts/15/regionalsetng.aspx Worth checking that for a test user. 4. Force via PowerShell (Org-wide defaults) There’s no single tenant-wide switch sadly. But you can script updates to: Mailbox region settings (Set-MailboxRegionalConfiguration) SharePoint site defaults (Set-SPOSite -LocaleId 2057 for UK) Example for a user mailbox: Set-MailboxRegionalConfiguration -Identity [email protected] -Language en-GB -DateFormat "dd/MM/yyyy" -TimeFormat "HH:mm" -TimeZone "GMT Standard Time" This makes sure calendar, dates, and times stick to UK formats. ⚠️ Reality Check There’s no single “force UK for everyone” button (annoying, I know). It’s a combo of: Tenant defaults SharePoint defaults User profile language/region Mailbox regional config If any of those are unset, Office apps often slip back into en-US. 👉 My recommendation: Set org defaults (which you’ve mostly done) Run a PowerShell script to bulk set mailbox regional settings for all users Educate staff to check/update their own My Account → Settings & Privacy → Language & Region

Typo on link mdrabble

Did you ever get to the bottom of this Rob??

What a steep learning curve this TEAMS administrating was 🙈

Ditto 👍

FOG works a charm 👍

Second this, also their support team are very responsive

Hi rpycroft, would this post suit a recent computing uni graduate?