Forum Discussion
Question related to Date value
Hello Everyone,
I am using dd/mm/yyyy. So, How can i lock the date field in a specific format so that when i share the file with other users to update the date , they do not change the date format(dd/mm/yyyy) and use the same format as i required?
OR
What should i write in Custom in Data Validation setting?
Like -
Please help...???
6 Replies
- Does it mean that it is not possible to do that?
- Ok. Thank you for the help sir😊😊
I think it would be more complicated than it's worth.
If your workbook will be used by people using different date formats (dd/mm/yyyy, m/d/yy, yyyy-mm-dd, ....), I recommend using the custom format d-mmm-yyyy (for example 23-Mar-2021). This format avoids ambiguity and should be easy to understand for every user.
Everyone can still enter dates the way they are used to: you would enter 23/03/2021, I would enter 2021-03-23, and an American would enter 3/23/21. The cell will display 23-Mar-2021 in all cases.
In Data Validation, select Date from the Allow dropdown, and specify a suitable date range.
Thank you for the reply sir.
But how to set dd/mm/yyyy in data validation?I wouldn't do that. It will be confusing for someone using the USA date system m/d/yyyy to enter dates as dd/mm/yyyy.
