Home

UK Date format

%3CLINGO-SUB%20id%3D%22lingo-sub-435744%22%20slang%3D%22en-US%22%3EUK%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-435744%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20here%20and%20will%20appreciate%20some%20help%20with%20Excel%20Online%3C%2FP%3E%3CP%3EI%20wish%20to%20format%20my%20dates%20in%20a%20single%20column%20as%20dd%2Fmm%2Fyy%20for%20UK%20format.%20My%20Control%20Panel%20options%20are%20set%20to%20locale%20of%20English%20(United%20Kingdom).%3C%2FP%3E%3CP%3EIdeally%20I%20would%20like%20to%20be%20able%20to%20type%2011%2F04%20into%20a%20cell%20which%20should%20appear%20as%2011%2F04%2F19%20but%20it%20instead%20appears%20as%2004%2F11%2F19%20despite%20the%20format%20being%20set%20correctly.%20This%20is%20obviously%20frustrating.%3C%2FP%3E%3CP%3ELooking%20at%20the%20attached%20screenshot%2C%20the%20first%20few%20dates%20in%20the%20column%20are%20set%20to%20text%20format%20because%20I%20was%20experimenting.%20The%20next%20few%20are%20formatted%20as%20short%20date%20UK.%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-435744%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438929%22%20slang%3D%22en-US%22%3ERe%3A%20UK%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438929%22%20slang%3D%22en-US%22%3EDoes%20this%20help%20perhaps%3A%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_other%2Fexcel-online-how-to-change-regional-settings%2F03862c3c-8f32-42cf-961c-112f0f1fd790%3Fauth%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_other%2Fexcel-online-how-to-change-regional-settings%2F03862c3c-8f32-42cf-961c-112f0f1fd790%3Fauth%3D1%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438979%22%20slang%3D%22en-US%22%3ERe%3A%20UK%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438979%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319219%22%20target%3D%22_blank%22%3E%40Michael188%3C%2FA%3E%26nbsp%3B%2C%20yes%2C%20as%20Jan%20Karel%20answered%20you%20shall%20to%20define%20UK%20locale%20for%20your%20OneDrive%2C%20not%20for%20PC.%20Settings%20are%20different%20depends%20on%20you%20use%20OneDrive%20Personal%20or%20Business%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-443261%22%20slang%3D%22en-US%22%3ERe%3A%20UK%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443261%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%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%20I%20have%20asked%20my%20internal%20IT%20support%20to%20update%20that%20option%20within%20OneDrive%20(which%20is%20currently%20not%20a%20valid%20locale)%20and%20I%20will%20respond%20back%20later%20when%20it%20has%20been%20done.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Michael188
New Contributor

I am new here and will appreciate some help with Excel Online

I wish to format my dates in a single column as dd/mm/yy for UK format. My Control Panel options are set to locale of English (United Kingdom).

Ideally I would like to be able to type 11/04 into a cell which should appear as 11/04/19 but it instead appears as 04/11/19 despite the format being set correctly. This is obviously frustrating.

Looking at the attached screenshot, the first few dates in the column are set to text format because I was experimenting. The next few are formatted as short date UK.

Thank you!

3 Replies

@Michael188 , yes, as Jan Karel answered you shall to define UK locale for your OneDrive, not for PC. Settings are different depends on you use OneDrive Personal or Business one.

@Sergei Baklan 

@Jan Karel Pieterse 

Thank you. I have asked my internal IT support to update that option within OneDrive (which is currently not a valid locale) and I will respond back later when it has been done.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies