Fix French Date and Regional Settings in Excel Online
Question details
Set Excel Online to accept French-style date input and use appropriate regional behavior.

- 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.
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.
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.
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.
Under Site Administration, select Regional settings. Set Locale to French (France) and Sort Order to General rather than French.
Save the regional settings, sign out of Microsoft 365, and then sign in again.
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.

Use the site administrator's regional settings in your profile
Check your personal settings if the site locale is correct but Excel Online still uses different regional behavior.
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.

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.




