Forum Discussion
thomasmartinez
Feb 04, 2020Copper Contributor
Date format microsoft teams
Hello everyone, I work as an IT Support Tech in a company. Today, a user came with a date format issue on excel but only in teams. She tried to put a french date format in teams, but the ...
thomasmartinez
Feb 06, 2020Copper Contributor
Hello ChrisHoardMVP
Thank you for your answer.
I tried myself to do the issue on team, here is the point:
- All my account settings are in French.
- I want the format date to be in French, so this format: DD-MM-YYYY
- When I write the date in the french format in teams, the soft keep change it in english format : MM-DD-YYYY
- The format date in the soft settings is in full english.
In this screenshots, I wrote the date in french format, in the cell it appears in english format. In the row "Ajout" I add 15 days at the first date, and still add it in the bad format.
I wanted to write "06/02/2020" as 6th February 2020.
Thank you in advance.
Bikky
Mar 15, 2021Copper Contributor
That's not English. That's American date format. It annoys us English too, because we use dd/mm/yy or yyyy
TBH I'm sick of the windows regioning always placing you in US despite what selections you make.
TBH I'm sick of the windows regioning always placing you in US despite what selections you make.
- MattwinterrshqJul 20, 2021Copper ContributorHear!! Hear!! totally agree!