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

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

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.

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

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 Region2. Click on Additional Settings3. Click on Date tab4. In the Short Date, you can specify desired format i.e. dd/mm/yyyy 5. Click on Apply and OKAs said earlier,all your applications will follow the specified date format going forward...

Microsoft Teams Excel date formatting issue

SergeiBaklan
MVP
Mar 02, 2020
smold2105

What are your regional settings for the connected Sharepoint site?
- smold2105
  Copper Contributor
  Mar 03, 2020
  SergeiBaklan We do not have sharepoint on our computers
  - SergeiBaklan
    MVP
    Mar 03, 2020
    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.
Abiola1
MVP
Mar 02, 2020
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...
- smold2105
  Copper Contributor
  Mar 03, 2020
  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
  - 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.
SystemsFirst
Copper Contributor
Dec 06, 2022
smold2105

Posting here to assist others. Things to check when your date is wrong.

Systems regional settings. Check your PC's Regional Format is correct.
Office 365 Settings - File-> Options -> Language.
Also Check the Date formatting for cells - Right Click a Cell with Date -> Format Cell -> Check "Locale"
Check Teams "..." Three dots top right next to your profile. -> General -> App Language
Here is the kicker that I have found to be wrong with some users.
Check the Date formatting while IN an excel document IN Teams.
ie. Be in Teams - Have a shared Excel Document in that team open (still in teams) -> Right click a cell with a date as above and check the Locale.
NOTE: This may be related to the formatting/regional settings of the site on SharePoint and i have not fully tested this yet - If you do not have admin access to the SharePoint site, this is your fix.
Other Note: If you have to Delete your %appdata% for Teams to resolve any issues, you will need to apply the above fix again also.
Hope this helps someone out there.
Cheers.

Forum Discussion

Microsoft Teams Excel date formatting issue

Share

Resources