Forum Discussion

bnunya's avatar
bnunya
Copper Contributor
Apr 14, 2019

Default Date Input Format.... Shared files

I know this question comes up all the time... but I have a new spin.  Changing the computer region settings and the account region settings are not fixing this problem.  We are using a shared Excel file and it isn't working for anybody else (we are an international group)... I've tried changing their settings on their computer or tablet, and tried changing the settings in their account.... nothing.  I built the file on a computer with mm/dd/yy regional settings, but with an account with dd/mm/yy settings.   No matter what I change, or where I change it, the default input date for everybody using the file is mm/dd/yy…. There must be some setting in the file somewhere that is effecting this. Please advise

5 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    bnunya , how do you share your files? - file share on the server in within your corporate network, OneDrive, Dropbox, etc

    • bnunya's avatar
      bnunya
      Copper Contributor

      SergeiBaklan 

      The file is saved in SharePoint, some users are accessing the file by shared link, and others are accessing through Microsoft Teams

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        bnunya 

        So, we speak about Excel Online, not about desktop client, correct? It shall take SharePoint site locale settings.

Resources