Office Settings & Configuration

How to Set DD/MM/YYYY Date Format Across Microsoft 365

WPS Content Manager Oct 7, 2026 874 views

Question details

Users and organizations need to standardize their date display format to DD/MM/YYYY across various Microsoft 365 apps and services.

How to Apply the DD/MM/YYYY Date Format in Microsoft 365

Product: Microsoft 365
Device & OS: not provided
Scenario: Standardizing date formatting for personal accounts or organization-wide workflows in services like SharePoint, OneDrive, Power Automate, and Loop.
Observed behavior: Microsoft 365 services often default to the MM/DD/YYYY format or lack a unified toggle, requiring manual regional setting adjustments per user or per service.

Before you start

Confirm whether you are trying to change this format for your personal account or for an entire organization, as global changes across all Microsoft 365 services may require administrator access and PowerShell.

Solution 1Recommended

Change Personal Microsoft Account Regional Settings

Update your individual account's language and region preferences. This is the primary method to switch your default date format to DD/MM/YYYY for most personal Microsoft 365 apps.

By selecting a region that natively uses the DD/MM/YYYY format (such as the United Kingdom or Australia), your individual Microsoft 365 services will automatically adopt this date structure.

Access account settings

Sign in to your Microsoft account and navigate to the 'My Account' portal. Click on 'Settings & Privacy' or directly look for your profile information.

Open language and region settings

Locate the 'Language and region' menu under your profile settings.

Select a new region

Change your 'Regional format' to a location that utilizes the DD/MM/YYYY format, such as 'English (United Kingdom)'.

Save changes

Click 'Save'. You may need to sign out and sign back in for the new date formatting to reflect across your web apps.

Change Personal Microsoft Account Regional Settings

Synchronization Delay: It can take up to 24 hours for regional format changes to sync across all connected Microsoft 365 services like OneDrive and Loop.

Solution 2

Update SharePoint Site Regional Settings

Since SharePoint utilizes its own site-collection settings, you must manually adjust the regional settings within specific SharePoint sites to display the DD/MM/YYYY format.

Free Microsoft Office alternative

Experience Easier Formatting with WPS Office

Tired of navigating complex admin centers and fragmented regional settings across different apps? WPS Office provides a streamlined, lightweight desktop alternative for all your document, spreadsheet, and presentation needs, making date formatting effortless.

1. Download the installer: Visit the official WPS Office website and download the free installer for your operating system.
2. Install WPS Office: Run the setup file and follow the quick on-screen instructions to install the suite.
3. Open and edit your files: Launch WPS Spreadsheets, open your existing Microsoft Excel files, and easily format your date columns to DD/MM/YYYY through the standard Format Cells menu.

Free to use with a lightweight installation processFully compatible with Microsoft Excel, Word, and PowerPoint file formatsEasily customize date formats (DD/MM/YYYY) directly in your spreadsheets without changing global account settingsFamiliar, intuitive user interface ensures a seamless transition from Microsoft Office

microsoft office alternative - wps office

Frequently Asked Questions

Where is the global Microsoft 365 admin setting to enforce DD/MM/YYYY for all users?

There is no single button in the Microsoft 365 Admin Center to force a date format across all services universally. Administrators must typically set default mailbox regional settings via PowerShell or configure SharePoint site defaults individually.

Why did my OneDrive date format not change after updating my account region?

OneDrive for Business is built on SharePoint infrastructure, meaning it may still adhere to regional settings applied at the tenant or site level. Additionally, caching can cause a delay of several hours before new regional formats appear.

Does changing my region to get DD/MM/YYYY affect my display language?

It can if you change the primary display language instead of just the regional format. Be sure to select a localized version of your preferred language (e.g., English - Australia) so the interface language remains the same while the date structure updates.

How do I ensure Power Automate uses DD/MM/YYYY?

Power Automate relies on ISO 8601 strings (YYYY-MM-DD) natively. To output DD/MM/YYYY, you must use the formatDateTime() expression within your flow, such as formatDateTime(triggerOutputs()?['body/Date'], 'dd/MM/yyyy').

Office App Problems