Forum Discussion

Copper Contributor

Mar 02, 2020

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...

excel

Excel for web

SergeiBaklan

MVP

Mar 03, 2020

smold2105

Yes, SharePoint is not on your computers, it's in the cloud. If you have Teams, you have SharePoint, that's where Teams keep files. In Files tab within Team it shall be Open in SharePoint item of the menu. If open, you may check regional settings for the sharepoint site.

smold2105

Copper Contributor

Mar 04, 2020

SergeiBaklan I have no option to open in sharepoint and have checked with our IT department and they have said we do not have sharepoint. I only get the option to open in teams or in browser from files. not sharepoint

SergeiBaklan
MVP
Mar 04, 2020
smold2105

Could you please share how within Teams your Files tab looks like
- smold2105
  Copper Contributor
  Mar 04, 2020
  SergeiBaklan please see the below
  - SergeiBaklan
    MVP
    Mar 04, 2020
    smold2105
    
    I see, thank you. I'm not so familiar with Teams and have no idea why Sharepoint is not visible. But your files are definitely somewhere in the cloud (you see Upload, Sync, Download) and I believe regional setting are to be adjusted for that cloud storage.
    
    Perhaps if ask Teams community here they could help.