UK Date format

SergeiBaklan 

Hi Sergei

In my hunt for an answer re an almost identical issue, I have seen your name pop up several times providing a successful solution, but i still can't get this to work.

My issue:

• I have an office 365 business subscription.  I normally open the spreadsheet on my desktop and all is well (UK date format works perfectly).  However, if I (or four other UK users) access it online:
  • Date format appears:
    • correctly (as UK date format) in cell
    • incorrectly (as US date format) in Formula Bar  
  • Typing:
    • 1/2 in a cell (i.e. 1st Feb UK), generates 2/1 in the cell (i.e. 2nd Jan UK). 
    • 31/10 in a cell is not recognised as a date

So far:

• I've set to English (UK)/(UTC+00:00) Dublin, Edinburgh, Lisbon where possible:
  • Control Panel, Region 
  • One Drive, Regional Settings
  • Microsoft 365 admin center, settings
  • Excel - Cell Number Format
• I've also tried using custom dates in Excel desktop to no avail

Do you have any other suggestions?

Cheers 

Helen