Forum Discussion
Microsoft Teams Excel date formatting issue
kinoom No because all my language settings on Teams and the computer are set to UK English and I still get this issue
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.
- SergeiBaklanFeb 02, 2021MVP
- CaroS1355Feb 23, 2021Copper Contributor
SergeiBaklan thanks, that last tip sorted out my issue
- NomaddUKFeb 24, 2021Copper Contributor
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.
- SergeiBaklanFeb 26, 2021MVP
Yes, that's not Excel, these are regional setting for your online storage. In particular, for the List within Teams you may click on three dots
and open it in SharePoint site. For this exact site you need to change regional settings on UK ones. Usually US settings are default - date and time format, first day of the week, time zone...
You have to have administrative rights for that. If you don't have ask your admins to change these settings.