Microsoft Teams Excel date formatting issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1204776%22%20slang%3D%22en-US%22%3EMicrosoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204776%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20an%20excel%20sheet%20through%20teams.%20my%20date%20and%20region%20formats%20are%20set%20to%20UK%20on%20my%20PC%2C%20the%20browser%2C%20teams%20and%20my%20Microsoft%20account.%20however%20i%20type%20the%20date%20in%20dd%2Fmm%2Fyy%20format%20and%20excel%20opened%20in%20the%20browser%20through%20teams%20changes%20it%20to%20mm%2Fdd%2Fyy.%20this%20was%20working%20fine%20using%20the%20dd%2Fmm%2Fyy%20format%20and%20then%20suddenly%20wasn't%20working%20and%20started%20changing%20it%20to%20the%20mm%2Fdd%2Fyy%20format%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1204776%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204805%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204805%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572468%22%20target%3D%22_blank%22%3E%40smold2105%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20are%20your%20regional%20settings%20for%20the%20connected%20Sharepoint%20site%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204921%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204921%22%20slang%3D%22en-US%22%3EHello%2C%20bases%20on%20my%20experience%2C%20one%20you%20change%20your%20Date%20Format%20from%20your%20computer%20or%20laptops%20Regional%20Settings%2C%20all%20your%20applications%20obey%20the%20format%20including%20Microsoft%20Excel%2C%20Microsoft%20Teams%20etc...%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20permanently%20change%20your%20Date%20Format%3A%3CBR%20%2F%3E1.%20In%20your%20Control%20Panel%2C%20click%20on%20Change%20Date%2C%20Time%20or%20Number%20Formats%20under%20the%20Clock%20and%20Region%3CBR%20%2F%3E2.%20Click%20on%20Additional%20Settings%3CBR%20%2F%3E3.%20Click%20on%20Date%20tab%3CBR%20%2F%3E4.%20In%20the%20Short%20Date%2C%20you%20can%20specify%20desired%20format%20i.e.%20dd%2Fmm%2Fyyyy%20%3CBR%20%2F%3E5.%20Click%20on%20Apply%20and%20OK%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20said%20earlier%2Call%20your%20applications%20will%20follow%20the%20specified%20date%20format%20going%20forward...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1205905%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1205905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BWe%20do%20not%20have%20sharepoint%20on%20our%20computers%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1205909%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1205909%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BLike%20i%20said%20in%20my%20original%20post%2C%20all%20the%20settings%20are%20set%20to%20the%20correct%20region%20on%20my%20PC%2C%20teams%2C%20the%20browser%20and%20my%20microsoft%20account%20so%20this%20has%20not%20worked%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1207069%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1207069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572468%22%20target%3D%22_blank%22%3E%40smold2105%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20SharePoint%20is%20not%20on%20your%20computers%2C%20it's%20in%20the%20cloud.%20If%20you%20have%20Teams%2C%20you%20have%20SharePoint%2C%20that's%20where%20Teams%20keep%20files.%20In%20Files%20tab%20within%20Team%20it%20shall%20be%20Open%20in%20SharePoint%20item%20of%20the%20menu.%20If%20open%2C%20you%20may%20check%20regional%20settings%20for%20the%20sharepoint%20site.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208304%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208304%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20have%20no%20option%20to%20open%20in%20sharepoint%20and%20have%20checked%20with%20our%20IT%20department%20and%20they%20have%20said%20we%20do%20not%20have%20sharepoint.%20I%20only%20get%20the%20option%20to%20open%20in%20teams%20or%20in%20browser%20from%20files.%20not%20sharepoint%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208319%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572468%22%20target%3D%22_blank%22%3E%40smold2105%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20share%20how%20within%20Teams%20your%20Files%20tab%20looks%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F174987i3C498C099F629DCC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208321%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208321%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bplease%20see%20the%20below%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208373%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572468%22%20target%3D%22_blank%22%3E%40smold2105%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20see%2C%20thank%20you.%20I'm%20not%20so%20familiar%20with%20Teams%20and%20have%20no%20idea%20why%20Sharepoint%20is%20not%20visible.%20But%20your%20files%20are%20definitely%20somewhere%20in%20the%20cloud%20(you%20see%20Upload%2C%20Sync%2C%20Download)%20and%20I%20believe%20regional%20setting%20are%20to%20be%20adjusted%20for%20that%20cloud%20storage.%3C%2FP%3E%0A%3CP%3EPerhaps%20if%20ask%20Teams%20community%20here%20they%20could%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1490798%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1490798%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572468%22%20target%3D%22_blank%22%3E%40smold2105%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EDid%20you%20solve%20this%3F%26nbsp%3B%3CBR%20%2F%3EI%20had%20the%20same%20issue%20and%20resolved%20it%20by%20changing%20the%20language%20setting%20found%20when%20clicking%20on%20my%20profile%20pic%20in%20Teams.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491341%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20Excel%20date%20formatting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491341%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710666%22%20target%3D%22_blank%22%3E%40kinoom%3C%2FA%3E%26nbsp%3BNo%20because%20all%20my%20language%20settings%20on%20Teams%20and%20the%20computer%20are%20set%20to%20UK%20English%20and%20I%20still%20get%20this%20issue%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 excel opened in the browser through teams changes it to mm/dd/yy. this was working fine using the dd/mm/yy format and then suddenly wasn't working and started changing it to the mm/dd/yy format

11 Replies
Highlighted

@smold2105 

What are your regional settings for the connected Sharepoint site?

Highlighted
Hello, bases on my experience, one you change your Date Format from your computer or laptops Regional Settings, all your applications obey the format including Microsoft Excel, Microsoft Teams etc...

To permanently change your Date Format:
1. In your Control Panel, click on Change Date, Time or Number Formats under the Clock and Region
2. Click on Additional Settings
3. Click on Date tab
4. In the Short Date, you can specify desired format i.e. dd/mm/yyyy
5. Click on Apply and OK


As said earlier,all your applications will follow the specified date format going forward...
Highlighted

@Sergei Baklan We do not have sharepoint on our computers 

Highlighted

@Abiola1 Like i said in my original post, all the settings are set to the correct region on my PC, teams, the browser and my microsoft account so this has not worked

Highlighted

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

Highlighted

@Sergei Baklan 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

Highlighted

@smold2105 

Could you please share how within Teams your Files tab looks like

image.png

 

Highlighted

@Sergei Baklan please see the below

Highlighted

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

Highlighted

@smold2105 

Did you solve this? 
I had the same issue and resolved it by changing the language setting found when clicking on my profile pic in Teams.

Highlighted

@kinoom No because all my language settings on Teams and the computer are set to UK English and I still get this issue