Excel date

%3CLINGO-SUB%20id%3D%22lingo-sub-2597669%22%20slang%3D%22en-US%22%3EExcel%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597669%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I'm%20working%20on%20an%20on-line%20Excel%20document%20%26amp%3B%20no%20matter%20how%20many%20times%20I%20change%20the%20date%20format%20to%2002%2F08%2F2021%20English-UK%2C%20it%20keeps%20reverting%20to%20Armenian%3F%3F%3F%26nbsp%3B%20Have%20also%20changed%20it%20in%20the%20File%20Options%20section.%20Please%20help%20-%20thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2597669%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597918%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597918%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118187%22%20target%3D%22_blank%22%3E%40Anita_Melaniphy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnita%2C%20perhaps%20you%20used%20that%2C%20regional%20settings%20could%20be%20changed%20from%20File%20menu%20here%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%20688px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299865i9BBB66F32A28D7C0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597895%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597895%22%20slang%3D%22en-US%22%3EThank%20you%20-%20have%20managed%20to%20sort%20out%20the%20problem%20(once%20I%20enabled%203rd%20party%20cookies%2C%20I%20was%20able%20to%20change%20the%20regional%20settings).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597890%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597890%22%20slang%3D%22en-US%22%3EYou%20can%20also%20try%20to%20change%20the%20date%20of%20your%20computer%20system%20itself%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597887%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597887%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20change%20the%20format%20using%20the%20Format%20Cells%20Dialog%20box.%3CBR%20%2F%3E%3CBR%20%2F%3EPress%20Ctrl%20%2B%201%2C%20Go%20to%20the%20Date%20option.%20Under%20the%20Locale%20section%2C%20select%20the%20Location%20of%20which%20you%20want%20to%20display%20the%20date.%20I%20hope%20this%20helps%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597834%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597834%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%3E1)%26nbsp%3B%20Yes%3C%2FP%3E%3CP%3E2)%26nbsp%3B%20Yes%20-%20only%20I%20have%20formatted%20it%20to%2002%2F08%2F2021%3C%2FP%3E%3CP%3E3)%26nbsp%3B%20Yes%2C%20when%20file%20reopened%20it%20reverts%20to%20US%20format%20(but%20showing%20Armenian%20in%20the%20cell%20format%20location)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20change%20the%20location%20to%20remain%20as%20UK%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20tks%3C%2FP%3E%3CP%3EAnita%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597817%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118187%22%20target%3D%22_blank%22%3E%40Anita_Melaniphy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%3C%2FP%3E%0A%3CP%3E1)%20you%20are%20on%20Excel%20for%20web%3C%2FP%3E%0A%3CP%3E2)%20when%20you%20change%2008%2F02%2F2021%20to%20UK%20date%20format%20you%20see%2002.08.2021%3C%2FP%3E%0A%3CP%3E3)%20when%20you%20reopen%20the%20file%20format%20goes%20back%20to%20US%20one%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOr%20step%202%20doesn't%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi I'm working on an on-line Excel document & no matter how many times I change the date format to 02/08/2021 English-UK, it keeps reverting to Armenian???  Have also changed it in the File Options section. Please help - thank you.

6 Replies

@Anita_Melaniphy 

Do you mean

1) you are on Excel for web

2) when you change 08/02/2021 to UK date format you see 02.08.2021

3) when you reopen the file format goes back to US one?

 

Or step 2 doesn't work?

@Sergei Baklan 

1)  Yes

2)  Yes - only I have formatted it to 02/08/2021

3)  Yes, when file reopened it reverts to US format (but showing Armenian in the cell format location)

 

Is there a way I can change the location to remain as UK?

 

Many tks

Anita

Hi,

You can change the format using the Format Cells Dialog box.

Press Ctrl + 1, Go to the Date option. Under the Locale section, select the Location of which you want to display the date. I hope this helps
You can also try to change the date of your computer system itself
Thank you - have managed to sort out the problem (once I enabled 3rd party cookies, I was able to change the regional settings).

@Anita_Melaniphy 

Anita, perhaps you used that, regional settings could be changed from File menu here

image.png