Forum Discussion
Excel
Mar 23, 2021Iron Contributor
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(d...
Excel
Mar 23, 2021Iron Contributor
Thank you for the reply sir.
But how to set dd/mm/yyyy in data validation?
HansVogelaar
Mar 23, 2021MVP
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.