Date formatting

[ihipera_rs]

Using a share file on Microsoft Teams
Problem: I add data every day and my team use the data for reporting within the sharefile. Every day when we enter Teams and update the data, the dates we use revert to English (US) or Armenian. The date columns are formatted to dd/mm/yyyy using custom numbering, and that shows when the spreadsheet is opened in Excel. However, as soon as it is on Teams, it reverts.

Any help to stop this from happening and maintain the format I have chosen?

 

[DanteAmor]

Hi and welcome to MrExcel!

Review this:

Change the Windows regional settings to modify the appearance of some data types - Microsoft Support

support.office.com

 

[ihipera_rs]

Thank you!

I formatted my PC, but no change to the web version of the workbook.
Any way to permanently format the date settings for an online version?