How do I show dates in UK format in an Excel when viewed in a browser?

We have a sheet on SharePoint for Daily Standup notes. If I open the document in my browser, the date format is mm/dd/yyyy (incorrect). If I open in the desktop application, the dates show as dd/mm/yyyy (correct).

Browser-based view:

In Excel desktop application

My Account shows that my regional settings are UK as expected.

How do I have Excel browser viewer show the correct date format?

Solution 1:

With the file open in the online app, go to File > Options

And then Regional format settings and check that is set to "English (United Kingdom)".

If you change this then the file should re-load and display correctly.