Office Settings & Configuration

Fix French Date and Regional Settings in Excel Online

Nimra MalikNimra Malik Nov 20, 2026 869 views

Question details

Set Excel Online to accept French-style date input and use appropriate regional behavior.

Fix French Date and Regional Settings in Excel Online
Product
Microsoft Excel Online and OneDrive for Business
Device & OS
not provided
Scenario
A user enters dates and uses date formulas in a workbook stored in OneDrive for Business.
Observed behavior
Dates display in French format, but Excel Online requires English-style date entry and date formulas behave incorrectly.
Before you start

Confirm that the workbook is stored in OneDrive for Business and that you can access its site settings. If regional settings are unavailable, ask your Microsoft 365 administrator for help.

Solution 1Recommended

Set the OneDrive locale to French and sort order to General

Use this fix when French date formatting appears correctly but date entry still follows English conventions.

In the reported case, switching the sort order from French back to General resolved the date-entry problem. The available settings and navigation can vary by Microsoft 365 configuration.

1
Open site settings

In OneDrive for Business, open Settings using the gear icon and look for Site settings. If it is not available, ask your administrator to open the site's settings.

2
Change regional settings

Under Site Administration, select Regional settings. Set Locale to French (France) and Sort Order to General rather than French.

3
Save and sign in again

Save the regional settings, sign out of Microsoft 365, and then sign in again.

4
Test date entry

Reopen the workbook in Excel Online and enter an unambiguous French-style date, such as 31/12/2025, in a blank cell. Use =ISNUMBER(cell reference) in another cell to check whether Excel recognized it as a date value.

Set the OneDrive locale to French and sort order to General
Allow time for changes: Regional changes may take some time to apply. Date display format alone does not confirm that an entry was recognized as a date.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format support for an easier move between apps. It does not change Excel Online or OneDrive regional settings.

Open and edit Microsoft Excel XLSX and XLS filesFormat and work with dates in WPS SpreadsheetsUse familiar spreadsheet menus and toolsMove existing Office files into a lightweight workspace
microsoft office alternative - wps office

Frequently Asked Questions

Why do dates look French but require English-style entry?

A cell's display format can differ from the regional settings used to interpret input. Check the OneDrive for Business site's locale and sort order, then test a new date entry.

Which sort order should I use with the French locale?

In the reported case, setting Locale to French (France) and Sort Order to General in Site settings > Regional settings resolved the issue.

How can I tell whether Excel recognized my entry as a date?

Enter the date in a blank cell, then use =ISNUMBER(cell reference) in another cell. A TRUE result indicates that the entry is stored as a number, as Excel dates normally are.

What if I cannot find the regional settings?

Check the Settings gear in OneDrive for Business for Site settings. If the option is missing or you cannot edit it, ask your Microsoft 365 administrator to review the site's regional settings.

Will changing the locale translate my formulas?

Not necessarily. Formula language and regional behavior can depend on Microsoft 365 language settings as well as locale. Test the formulas you use after changing the settings.