Incorrect Date format in Files on Teams/SharePoint - Private Channels

Incorrect Date format in Files on Teams/SharePoint - Private Channels

The below images are from the PC desktop version of Teams, menu layout may differ slightly depending on the version of Teams you are using.

Issue:  Dates in files (particularly Excel) are showing in American date format MM/DD/YY instead of Australian date format DD/MM/YY

Solution:  Regional Settings for the Private Channel need to be changed from USA to Australia

The date format for new private channels defaults to US, and due to how private channels operate this needs to be update for Private Channels separately.

You will need to be the Owner of a Private Channel to make the below change

Open Teams and navigate to the Files tab of the Private Channel you need to update, then click on Open in SharePoint


This should open a new Tab or Window in your browser and;
1) If you are already logged into Office 365 take your directly to the SharePoint Page
2) Bring you to the Office 365 login screen - enter your account (or select from the list) and then click Next, when prompted enter your password

When logged in you should see a screen similar to the below confirming you are on the Private Channel SharePoint page


In the top right, there is a Cog/Gear symbol next to your name called Settings click on this

Click on Site Contents then on the next screen click on Site setting on the right hand side of the screen



On the next screen click on Regional settings listed under Site Administration


You will need to change the Locale from English (United States) to English (Australia)  then scroll down and click OK at the bottom of the page



This will bring you back to the Site Settings page - you can now close this Tab or Window.

The date formats in your document should now be in the correct date format.
    • Related Articles

    • Sync Teams files with OneDrive

      The advantages of syncing files from Teams using OneDrive is that you will be able to access the files offline and they are available through My Computer (Windows Explorer) making it easier to access, view and edit. To sync the files follow the steps ...
    • Setting up a Meeting using Teams

      A downloadable PDF version of this guide is available at the bottom of the page Installing Teams For best results it is recommended to you install the Microsoft Teams app – available free from: ...
    • Setting up Microsoft Teams on your PC/Mac or Mobile Device

      Microsoft Teams is a free download from Microsoft or the App Store/Google Play Store Please note the screenshots may vary to your device, images supplied are from a Windows 10 PC Setting up Teams on your PC or Mac Download the latest version of ...
    • Get started with Scouts Queensland Microsoft Office 365

      Hello, welcome to Microsoft Office 365. If you have received your an email advising your Microsoft Office 365 account has been created, this knowledge base article is designed to help you start using Office 365 with Scouts Queensland. All Members ...
    • Opening a shared mailbox as a separate mailbox (webmail)

      Opening a shared mailbox as a separate mailbox using Outlook on the Web (webmail) This guide will assist you in opening a shared mailbox in a separate window/tab so you can use it like a normal email account. You will need to log in with your Scout ...