Forum Discussion
smold2105
Mar 02, 2020Copper Contributor
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...
SystemsFirst
Dec 06, 2022Copper Contributor
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.