Formatting Issues

How to Fix Excel Date Formatting Not Syncing in SharePoint

Kushani Nimanthika Oct 12, 2026 868 views

Question details

Users need to resolve an issue where date formatting in an Excel workbook does not display uniformly for all users viewing it via SharePoint.

How to Fix Excel Date Formatting Not Syncing in SharePoint

Product: Microsoft Excel / SharePoint
Device & OS: not provided
Scenario: Collaborating on and viewing a shared Excel workbook stored on SharePoint across different accounts, browsers, or devices.
Observed behavior: The date format changes dynamically based on the viewer's regional settings or browser preferences, leading to inconsistent formatting instead of syncing the file owner's intended format.

Before you start

Verify that your browser's language preferences and your Microsoft account's regional settings are properly configured, as SharePoint prioritizes these defaults over the document's original formatting.

Solution 1Recommended

Apply a Custom Locale-Specific Date Format

Using a fixed custom date format with a specific locale code forces Excel to display the date uniformly for everyone, overriding individual user regional settings.

By default, Excel uses dynamic date formats (indicated by an asterisk * in the Format Cells menu) which automatically adapt to a user's local operating system or browser region. By changing this to a hardcoded custom format, you can lock the visual layout of your dates.

Select the Date Cells

Open your workbook in the Excel desktop app and highlight the rows or columns containing the dates you want to lock.

Open the Format Cells Menu

Right-click the selected area and choose 'Format Cells', or press the Ctrl + 1 keyboard shortcut.

Set a Custom Locale Format

Navigate to the 'Custom' category. In the 'Type' field, input a locale-specific format such as [$-en-US]mm/dd/yyyy or [$-en-GB]dd/mm/yyyy. Click 'OK' to apply.

Save and Sync

Save the file to ensure the new custom formatting syncs back to SharePoint. All users will now see this exact layout.

Apply a Custom Locale-Specific Date Format

Formatting Locked: Adding the locale code in brackets ensures Excel ignores local web browser and system settings when displaying the file on SharePoint.

Solution 2

Align Microsoft Account Regional Settings

Synchronizing regional settings between your Microsoft account and the file owner ensures that dates are interpreted and displayed using the same standard.

Solution 3

Adjust Workbook Regional Settings in Excel for the Web

Setting the workbook's default region directly in Excel Online can help establish a baseline for how dates are handled in the browser.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Collaboration

If complex regional settings in Microsoft Excel and SharePoint are causing persistent formatting headaches, consider switching to WPS Office. It provides robust spreadsheet editing, full compatibility with Excel formats, and highly reliable formatting retention across different devices.

1. Download WPS Office: Visit the official WPS website to download and install the free software suite on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file. Your original date formatting will be preserved seamlessly.
3. Collaborate via WPS Cloud: Save your document to WPS Cloud to share and collaborate with your team without worrying about browser-based regional conflicts.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Free, lightweight, and fast alternative to Microsoft Office.Retains your cell formatting consistently without aggressive regional auto-conversions.Built-in cloud collaboration features that are easy to configure.

Frequently Asked Questions

Why does my date format change when I open an Excel file from SharePoint?

When viewing files on SharePoint, Excel for the Web often detects your browser's language preferences or your personal Microsoft account's regional settings, adjusting the dates to match your local format rather than the document's original format.

Can I lock the date format so it doesn't change for other SharePoint users?

Yes. You can bypass local settings by applying a custom date format with a specific locale tag. Highlight your dates, go to 'Format Cells' > 'Custom', and enter a format like [$-en-US]mm/dd/yyyy to lock the display.

Does changing my web browser's language affect SharePoint Excel dates?

Yes. If your Microsoft account does not have a strict regional default enforced, SharePoint will fall back on your web browser's language and regional preferences to determine how dates and currencies should be displayed.

How do I check my workbook's regional settings in Excel Online?

Open the workbook in your browser, click 'File' in the top left corner, select 'Options', and then choose 'Regional Format Settings' to view or change the default region for that specific web session.

Document & File Issues