Share via

Excel online date format keeps reverting to US locale.

Anonymous
2023-02-07T11:24:03+00:00

Hello,

I have what seems to be an identical issue to Holusojay, listed last August. Link here: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-online-regional-format-keep-reverting-to-us/11eb6c83-143f-467a-b989-86ff49d06dda

My excel spreadsheets keep reverting from UK to US regional format whenever I log back into Microsoft 365 through my workplace Portal (using Citrix, if useful). This impacts such things as time and date format (inverting date/month orientation etc.), and any formulae requiring dates as a reference as the months and days are inverted. Sometimes it won't even recognise the formula as a date at all.

I followed the guidance given to the original question poster, amending my location settings to UK, but it resets back to US the next time I log back into my work portal and use Office 365. It doesn't seem to affect desktop excel, but I prefer to use the online version.

Any advice is welcome.

Josh

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-09T12:06:57+00:00

    Step 1 – Sign in to your Microsoft account

    Step 2 – Proceed to “Your info”

    Step 3 – Select “Regional formats”

    Step 4 – Configure options

    Reference：

    How to set default date format in Excel web app – Business Tech Planet

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-02-14T09:31:12+00:00

    Thank you Snow Lu. I can confirm all regional settings are set to UK. This only seems to affect Microsoft Excel online number format table - specifically the date format, which always reverts to English US. I change to English (UK) and amend the type accordingly, then tick to change to preferred regional locale, but each time I log out and back in again it has reverted to English (US), even though regional format is unchanged from UK.

    16 people found this answer helpful.
    0 comments
  3. Anonymous
    2023-02-14T11:16:26+00:00

    We had tried all the settings with time format.

    Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. That support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

    Contact Us - Microsoft Support

    1 person found this answer helpful.
    0 comments