Aug 02 2021 02:56 AM
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.
Aug 02 2021 06:43 AM
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?
Aug 02 2021 06:53 AM
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
Aug 02 2021 07:48 AM
Aug 02 2021 07:49 AM
Aug 02 2021 07:53 AM
Aug 02 2021 08:10 AM
Anita, perhaps you used that, regional settings could be changed from File menu here