Microsoft Teams Excel date formatting issue

Occasional Contributor

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 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

17 Replies

@smold2105 

What are your regional settings for the connected Sharepoint site?

Hello, bases on my experience, one you change your Date Format from your computer or laptops Regional Settings, all your applications obey the format including Microsoft Excel, Microsoft Teams etc...

To permanently change your Date Format:
1. In your Control Panel, click on Change Date, Time or Number Formats under the Clock and Region
2. Click on Additional Settings
3. Click on Date tab
4. In the Short Date, you can specify desired format i.e. dd/mm/yyyy
5. Click on Apply and OK


As said earlier,all your applications will follow the specified date format going forward...

@Sergei Baklan We do not have sharepoint on our computers 

@Abiola1 Like i said in my original post, all the settings are set to the correct region on my PC, teams, the browser and my microsoft account so this has not worked

@smold2105 

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.

@Sergei Baklan I have no option to open in sharepoint and have checked with our IT department and they have said we do not have sharepoint. I only get the option to open in teams or in browser from files. not sharepoint

@smold2105 

Could you please share how within Teams your Files tab looks like

image.png

 

@Sergei Baklan please see the below

@smold2105 

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.

@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.

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

@kinoom It worked for me, thank you very much! 

@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.

@NomaddUK 

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

image.png

@Sergei Baklan thanks, that last tip sorted out my issue

@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.

NomaddUK_0-1614155752955.png

 

@NomaddUK 

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

image.png

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.