Feb 04 2020 02:41 AM
Feb 04 2020 02:41 AM
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 software changed the date format all the time to put an english date.
When I opened the documents in excel in local, we could put a french format to a date.
Do you have any idea of where this issu can come from ?
Thank you in advance,
Feb 04 2020 03:17 AM
Feb 06 2020 12:22 AM
Hello @Christopher Hoard
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.
Jan 11 2021 03:49 AM
Christopher & Thomas,
Please note that MM/DD/YYYY is an AMERICAN date format ONLY, absolutely not UK English (and this is what it has always been referred to in the computer community since I started encountering this problem back in 1983).
In the UK (That's England, Scotland and Northern Ireland) we use MM/DD/YYYY as you do in France. We also have our own character set and keyboard layout (437 / UK English spring to mind) which is definitely not a US keyboard layout or character set or a French AZERTY keyboard layout (which befuddles everybody outside France and the 'Doms').
Back in the early days of windows programming all 'Locale' (i.e. what currency symbol/date format/language etc.) information was to be obtained ONLY from the machine on which you are running the programme (i.e. NEVER the server). I'm not aware this ever changed as it makes considerable sense, but I'm not a programmer any more so can't be sure.
If this is the case though it doesn't seem to be working with Microsoft Teams. I'm getting US short date format (MM/DD) when my machine is set to UK Locale with UK date formats which are the same as yours in France.
Advice on the forums is, as usual, patchy with some contributors seeming not to understand that there is a difference between US & UK/European date formats and counselling that changing local settings will put it right (which it should but doesn't).
Ho Hum - best of luck
Mar 15 2021 01:54 AM
Mar 15 2021 01:55 AM
Mar 15 2021 03:12 AM
Thanks Bikky - where it says "In the UK (That's England, Scotland and Northern Ireland) we use MM/DD/YYYY as you do in France." I did of course mean DD/MM/YYYY, so call it an important 'inadvertent typo'.
My point is this - the date format of any windows programme that follows Microsoft's own rules should get it's locale information from the workstation and use whatever that's set to to display currency, date etc. The excuse for teams appears to be that because it's a cloud based app it has to be set up individually by each user. To me that looks like a rather lame excuse.....
Mar 15 2021 03:17 AM