Microsoft Tech Community Live:  Microsoft Teams Edition
November 09, 2021, 08:00 AM - 12:00 PM (PST)

Date format microsoft teams

%3CLINGO-SUB%20id%3D%22lingo-sub-1149841%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20format%20microsoft%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1149841%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544351%22%20target%3D%22_blank%22%3E%40thomasmartinez%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20a%20uservoice%20open%20for%20this%20here%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F19166830-excel-dates%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F19166830-excel-dates%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWould%20recommend%20you%20vote%20on%20it%20to%20push%20it%20up%20the%20agenda.%20It%20ought%20to%20be%20possible%20to%20view%20Teams%20in%20one%20language%20and%20have%20the%20date%20format%20in%20excel%20in%20another.%20%3CBR%20%2F%3E%3CBR%20%2F%3EAFAIK%20the%20date%20format%20in%20Teams%20is%20determined%20by%20the%20language%20of%20the%20client.%20If%20you%20go%20to%20the%20menu%20(with%20the%20users%20picture)%20%26gt%3B%20settings%20%26gt%3B%20language%20can%20be%20changed%20here.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20answers%20your%20question%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1154889%22%20slang%3D%22fr-FR%22%3ERe%3A%20Date%20format%20microsoft%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1154889%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20myself%20to%20do%20the%20issue%20on%20team%2C%20here%20is%20the%20point%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20All%20my%20account%20settings%20are%20in%20English.%3C%2FP%3E%3CP%3E-%20I%20want%20the%20format%20date%20to%20be%20in%20English%2C%20so%20this%20format%3A%20DD-MM-YYYY%3C%2FP%3E%3CP%3E-%20When%20I%20write%20the%20date%20in%20the%20french%20format%20in%20teams%2C%20the%20soft%20keep%20change%20it%20in%20english%20format%3A%20MM-DD-YYYY%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20The%20format%20date%20in%20the%20soft%20settings%20is%20in%20full%20english.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20screenshots%2C%20I%20wrote%20the%20date%20in%20french%20format%2C%20in%20the%20cell%20it%20appears%20in%20english%20format.%20In%20the%20row%20%22Add%22%20I%20add%2015%20days%20at%20the%20first%20date%2C%20and%20still%20add%20it%20in%20the%20bad%20format.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wanted%20to%20write%20%2206%2F02%2F2020%22%20as%206th%20February%202020.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Visionneuse%20de%20fichiers%20XLSX%20%20Microsoft%20Teams.jpg%22%20style%3D%22width%3A%20781px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169346i46F4A4C8730B1C51%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Visionneuse%20de%20fichiers%20XLSX%20%20Microsoft%20Teams.jpg%22%20alt%3D%22XLSX%20file%20viewer%20Microsoft%20Teams.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Visionneuse%20de%20fichiers%20XLSX%20%20Microsoft%20Teams2.jpg%22%20style%3D%22width%3A%20636px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169347i21F3F59BE01E4F7F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Visionneuse%20de%20fichiers%20XLSX%20%20Microsoft%20Teams2.jpg%22%20alt%3D%22XLSX%20Microsoft%20Teams2.jpg%20File%20Viewer%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1149783%22%20slang%3D%22fr-FR%22%3EDate%20format%20microsoft%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1149783%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20work%20as%20an%20IT%20Support%20Tech%20in%20a%20company.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday%2C%20a%20user%20came%20with%20a%20date%20format%20issue%20on%20excel%20but%20only%20in%20teams.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShe%20tried%20to%20put%20a%20french%20date%20format%20in%20teams%2C%20but%20the%20software%20changed%20the%20date%20format%20all%20the%20time%20to%20put%20an%20english%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20opened%20the%20documents%20in%20excellent%20in%20local%2C%20we%20could%20put%20a%20french%20format%20to%20a%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20any%20idea%20of%20where%20this%20issu%20can%20come%20from%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1149783%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2048537%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20format%20microsoft%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2048537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544351%22%20target%3D%22_blank%22%3E%40thomasmartinez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChristopher%20%26amp%3B%20Thomas%2C%3C%2FP%3E%3CP%3EPlease%20note%20that%20MM%2FDD%2FYYYY%20is%20an%20AMERICAN%20date%20format%20ONLY%2C%20absolutely%20not%20UK%20English%20(and%20this%20is%20what%20it%20has%20always%20been%20referred%20to%20in%20the%20computer%20community%20since%20I%20started%20encountering%20this%20problem%20back%20in%201983).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20UK%20(That's%20England%2C%20Scotland%20and%20Northern%20Ireland)%20we%20use%20MM%2FDD%2FYYYY%20as%20you%20do%20in%20France.%20We%20also%20have%20our%20own%20character%20set%20and%20keyboard%20layout%20(437%20%2F%20UK%20English%20spring%20to%20mind)%20which%20is%20definitely%20not%20a%20US%20keyboard%20layout%20or%20character%20set%20or%20a%20French%20AZERTY%20keyboard%20layout%20(which%20befuddles%20everybody%20outside%20France%20and%20the%20'Doms').%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBack%20in%20the%20early%20days%20of%20windows%20programming%20all%20'Locale'%20(i.e.%20what%20currency%20symbol%2Fdate%20format%2Flanguage%20etc.)%20information%20was%20to%20be%20obtained%20ONLY%20from%20the%20machine%20on%20which%20you%20are%20running%20the%20programme%20(i.e.%20NEVER%20the%20server).%20I'm%20not%20aware%20this%20ever%20changed%20as%20it%20makes%20considerable%20sense%2C%20but%20I'm%20not%20a%20programmer%20any%20more%20so%20can't%20be%20sure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20is%20the%20case%20though%20it%20doesn't%20seem%20to%20be%20working%20with%20Microsoft%20Teams.%20I'm%20getting%20US%20short%20date%20format%20(MM%2FDD)%20when%20my%20machine%20is%20set%20to%20UK%20Locale%20with%20UK%20date%20formats%20which%20are%20the%20same%20as%20yours%20in%20France.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdvice%20on%20the%20forums%20is%2C%20as%20usual%2C%26nbsp%3B%20patchy%20with%20some%20contributors%20seeming%20not%20to%20understand%20that%20there%20is%20a%20difference%20between%20US%20%26amp%3B%20UK%2FEuropean%20date%20formats%20and%20counselling%20that%20changing%20local%20settings%20will%20put%20it%20right%20(which%20it%20should%20but%20doesn't).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHo%20Hum%20-%20best%20of%20luck%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2199996%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20format%20microsoft%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2199996%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544351%22%20target%3D%22_blank%22%3E%40thomasmartinez%3C%2FA%3E%26nbsp%3BThe%20only%20way%20i%20have%20accomplished%20this%20is%20to%20choose%20the%20column%2C%20and%20go%20to%20Format%20Cells%20and%20choose%20CUSTOM%20and%20then%20insert%20the%20format%20want%20mm%2Fdd%2Fyyyy%20or%20whatever%20date%20format%20you%20need.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22trecee-michele13_0-1615396854789.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262554iA385899171A18C20%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22trecee-michele13_0-1615396854789.png%22%20alt%3D%22trecee-michele13_0-1615396854789.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

 

 

9 Replies
Hi @thomasmartinez

There is a uservoice open for this here:

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/19166830-excel-dates

Would recommend you vote on it to push it up the agenda. It ought to be possible to view Teams in one language and have the date format in excel in another.

AFAIK the date format in Teams is determined by the language of the client. If you go to the menu (with the users picture) > settings > language can be changed here.

Hope that answers your question

Best, Chris

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.

Visionneuse de fichiers XLSX  Microsoft Teams.jpg

 

Visionneuse de fichiers XLSX  Microsoft Teams2.jpg

 

Thank you in advance.

@thomasmartinez 

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

@thomasmartinez The only way i have accomplished this is to choose the column, and go to Format Cells and choose CUSTOM and then insert the format want mm/dd/yyyy or whatever date format you need.  

trecee-michele13_0-1615396854789.png

 

 

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.
You use MM/DD/YYYY????? You're not English. it's DD/MM/YYYY in the UK. At least it has been since I went to School in the 70's

@Bikky 

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

 

With regard to Excel, I have this problem on one particular spreadsheet which I now believe to be slightly corrupt. It always thinks my dates are US and my currency keeps magically reverting to US$. My suspicion, but this is for another thread, is that the corruption has crept in because I share the spreadsheet with a colleague in India whose Locale, naturally enough, is Indian and that interleaved saves have corrupted the file. It is so badly damaged that I can copy the data from the affected sheets to a brand new correctly formatted XLXS and it takes the problem with it......
Hear!! Hear!! totally agree!