Forum Discussion
Excel date
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 s...
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 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