Forum Discussion

smold2105's avatar
smold2105
Copper Contributor
Mar 02, 2020

Microsoft Teams Excel date formatting issue

Hello,   I am using an excel sheet through teams. my date and region formats are set to UK on my PC, the browser, teams and my Microsoft account. however i type the date in dd/mm/yy format and exce...
excel
Excel for web
kinoom's avatar
kinoom
Copper Contributor
Jun 25, 2020

smold2105 

Did you solve this? 
I had the same issue and resolved it by changing the language setting found when clicking on my profile pic in Teams.

smold2105's avatar
smold2105
Copper Contributor
Jun 26, 2020

kinoom No because all my language settings on Teams and the computer are set to UK English and I still get this issue

  • NomaddUK's avatar
    NomaddUK
    Copper Contributor
    Feb 02, 2021

    smold2105 I also changed the language to UK in the profile but still get various sections and apps in Teams that do not follow the date format.  The big question here is why on Earth would anyone want to use a date format that makes no logical sense like mm/dd/yyyy? Programmatically it is a nightmare.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Feb 02, 2021

      NomaddUK 

      That's an option now directly in Excel Online/Teams and the File

      • NomaddUK's avatar
        NomaddUK
        Copper Contributor
        Feb 24, 2021

        SergeiBaklan Hi.  My issue is not specifically with Excel but with apps within Teams, in this case the built in Lists app.  

        It won't allow me to change to the more logically correct UK date format of dd/mm/yyyy for date fields but forces me to use mm/dd/yyyy.

         

Resources