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