Excel date format

%3CLINGO-SUB%20id%3D%22lingo-sub-1207181%22%20slang%3D%22en-US%22%3EExcel%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1207181%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20live%20in%20the%20UK.%20I%20followed%20the%20instructions%20in%20help%20to%20change%20the%20date%20from%20US%20to%20UK%20format.%26nbsp%3B%20It%20says%20in%20help%20that%20when%20you%20click%20on%20the%20date%20you%20want%20it%20will%20show%20in%20the%20sample%20box.%26nbsp%3B%20It%20does%20not%20and%20I%20am%20unable%20to%20change%20the%20date%20format.%26nbsp%3B%20Am%20I%20missing%20something%20or%20is%20this%20a%20question%20to%20be%20put%20to%20the%20Office%20365%20team%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1207181%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1207245%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1207245%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F242882%22%20target%3D%22_blank%22%3E%40Stephen%20Mummery%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20seeing%20your%20data%2C%20the%20guess%20is%20the%20cell%20is%20being%20treated%20as%20text%20and%20date%20formatting%20won't%20change%20anything.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

I live in the UK. I followed the instructions in help to change the date from US to UK format.  It says in help that when you click on the date you want it will show in the sample box.  It does not and I am unable to change the date format.  Am I missing something or is this a question to be put to the Office 365 team?

2 Replies
Highlighted

@Stephen Mummery 

Without seeing your data, the guess is the cell is being treated as text and date formatting won't change anything.

Highlighted
hello, once you successfully changed your date format to UK- dd/mm/yyyy in your Regional Settings, everything goes fine...