Forum Discussion
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...
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.
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.
