Microsoft Teams Excel date formatting issue

Hello,   I am using an excel sheet through teams. my date and region formats are set to UK on my PC, the browser, teams and my Microsoft account. however i type the date in dd/mm/yy format and exce...