Forum Discussion

thomasmartinez's avatar
thomasmartinez
Copper Contributor
Feb 04, 2020

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

 

 

  • 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
    • thomasmartinez's avatar
      thomasmartinez
      Copper 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's avatar
        Bikky
        Copper 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.
  • perastrom's avatar
    perastrom
    Copper Contributor
    Hi

    Maybe I'm a little late on the ball here 🙂 but...

    I have had the same problem with US date formats in teams and running teams in Swedish..... However, to solve this change the language settings for Teams in Teams on the web, then it will reflect in the installed application as well.
    • US_formatting_is_silly's avatar
      US_formatting_is_silly
      Copper Contributor

      Has anyone had any luck fixing this? I've tried editing the language in the browser but still says it wants US format dates (I'm not in excel, trying to add a custom date column in teams)

       

       

Resources