Can i change the Date-Format in OneDrive for my entire organization?

Question

Can i change the Date-Format in OneDrive for my entire organization?

Anonymous

My organisation is from Germany, so in the Excel App all of the time-formats are german (DD.MM.YYYY), but in Excel Web the date format is US(MM/DD/YYYY), which causes issues with some automation processes. I found that the standard in OneDrive is the US one and that you have to change it manually. I wanted to ask if there is any ways to change this setting globally?

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Hi @Schmidt, Thilo

Thank you for posting your question in the Microsoft Q&A forum.

Regarding your issue, unfortunately, Microsoft 365 does not provide a built-in option in the Microsoft 365 admin center to globally enforce regional settings (such as date format) across the entire tenant. The reason is that these settings are tied to individual user profiles and SharePoint/OneDrive site collections, not managed by a single global toggle.

But if you still want to standardize settings across OneDrive and SharePoint sites, you can try using PowerShell if you're comfortable with it. For more details, please refer to: Onedrive regional settings - Microsoft Q&A

While it's frustrating to rely on users, this is the easiest way to ensure the date format is correct for individual web sessions and new accounts. For more details, please refer to: Change your personal language and region settings.

Also, I suggest telling users to check/change Excel for the web’s locale settings when they open documents, which helps avoid date-format issues during their sessions. For more details, please refer to: Change regional format settings in Excel for the web.

Hope this clears things up and I apologize for the inconvenience this issue has caused and thank you for your understanding.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread