Excel date

Question

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

sergeibaklan · Answer

Anita_Melaniphy&nbsp;
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?
&nbsp;
Or step 2 doesn't work?

anita_melaniphy · Answer

SergeiBaklan&nbsp;1)&nbsp; Yes2)&nbsp; Yes - only I have formatted it to 02/08/20213)&nbsp; Yes, when file reopened it reverts to US format (but showing Armenian in the cell format location)&nbsp;Is there a way I can change the location to remain as UK?&nbsp;Many tksAnita

nidhiachhaa9 · Answer

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

nidhiachhaa9 · Answer

You can also try to change the date of your computer system itself

anita_melaniphy · Answer

Thank you - have managed to sort out the problem (once I enabled 3rd party cookies, I was able to change the regional settings).

Forum Discussion

Excel date

6 Replies

Resources