Mar 02 2020 08:44 AM
Mar 02 2020 08:44 AM
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 excel opened in the browser through teams changes it to mm/dd/yy. this was working fine using the dd/mm/yy format and then suddenly wasn't working and started changing it to the mm/dd/yy format
Mar 02 2020 09:45 AM
Mar 03 2020 09:09 AM
Yes, SharePoint is not on your computers, it's in the cloud. If you have Teams, you have SharePoint, that's where Teams keep files. In Files tab within Team it shall be Open in SharePoint item of the menu. If open, you may check regional settings for the sharepoint site.
Mar 04 2020 12:50 AM
I see, thank you. I'm not so familiar with Teams and have no idea why Sharepoint is not visible. But your files are definitely somewhere in the cloud (you see Upload, Sync, Download) and I believe regional setting are to be adjusted for that cloud storage.
Perhaps if ask Teams community here they could help.
Feb 02 2021 03:43 AM
@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.
Feb 24 2021 12:35 AM
@Sergei Baklan 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.
Feb 26 2021 12:15 PM
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.
Dec 05 2022 07:44 PM
Posting here to assist others. Things to check when your date is wrong.
Here is the kicker that I have found to be wrong with some users.
Hope this helps someone out there.