Regional format settings in Excel affect dates, currency, formula delimiters and more. If you are using your organization account, the default regional format settings in Excel for the web are the site regional settings of the SharePoint site where the Excel workbook is hosted.

This article provides steps to change just your own regional format settings in Excel for the web. During your Excel for the web sessions, the SharePoint site regional settings will be overridden. Your preferences are stored using a third-party cookie. Your regional settings will only apply to your view of Excel workbooks – it will not affect how other people view these workbooks.

Important: 

  • If your third-party cookies in the browser are disabled, you will not be able to change the regional format settings this way.

  • This feature is only available for files stored on Microsoft hosts.

Set the preferred regional format in Excel for the web 

  1. Click File > Options > Regional Format Settings.

    Regional Format Settings button on the File > Options menu

  2. Click the regions drop-down, select a region, and then click Change.

    Change regional format settings dialog

Your browser session refreshes using the new setting.

Regional format can also be set from the Number Format dialog.

  1. Click Home > Number FormatMore number formats...

    Number Format menu with the More Number Formats option highlighted.

  2. Under Category, click Date, Time, or Special, and then select a locale from the Locale menu.

  3. Select the checkbox to set the chosen locale as your default regional format, and then click OK

    Number Format dialog with the Regional Formats check box highlighted.

Your browser session refreshes and uses the new setting.

See Also 

Change your personal language and region settings

Change regional settings for a site

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×