I work in a UK based company and we've recently been using Microsoft Teams more and more, which for the most part has been great. However, whenever someone edits an Excel workbook within the Teams web (or desktop) app, they realise that datetime values are in the US format (MM/DD/YYYY). This seems to happen even if they have previously set the regional settings to UK in SharePoint / Office 365. If you haven't yet set the regional settings for the Office 365 group's SharePoint site, then you should do that first. If you have then you can skip this step.
Microsoft Teams & OneDrive - Fix issue with Excel date formats
· 3 min read
Automation Specialist