Share via

Cannot change the date format for the new Microsoft Lists

Anonymous
2021-09-10T10:32:14+00:00

My OD regional settings are UK, but the template lists still use US format in MS team, how to format to UK format dd/mm/yyyy for the new Microsoft Lists in MS team channel. Has anyone got any ideas?

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2021-09-10T13:01:59+00:00

Hi Allanpeter-890,

As per your description, I understand you want to change the date format (UK format dd/mm/yyyy ) for Microsoft Teams list .

For the Date and time column in Microsoft list in Microsoft team, the date format varies based on the regional settings for the site. 

Based on my test result, you should change the regional settings for the team site (when you create a team in Microsoft Teams, a SharePoint site with the same name will also be created).

Here are the steps

1.You can click "…" and select "Open in SharePoint" to open the related site. 

2.Select Settings(Gear icon) button from SharePoint Online , then select Site Settings.  

3.On the Site Settings page, in the Site Administration section, select Regional Settings

4.Change the regional to UK and select OK. 

Before

After

 

I appreciate your understanding and stay safe!! 

Best Regards 

Waqas Muhammad

Was this answer helpful?

3 people found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2021-09-10T18:06:16+00:00

    Worked Thanks!!

    Was this answer helpful?

    0 comments No comments