Is there a way to ensure data validation with date formats? If the user enters numbers not formatted in "mm/dd/yyyy" or "m/d/yy" format, is there a way to validate that using the data validation drop down?
Is there a way to ensure data validation with date formats? If the user enters numbers not formatted in "mm/dd/yyyy" or "m/d/yy" format, is there a way to validate that using the data validation drop down?
Data validation provides a Date option by which you may specify a variety of criteria.
Have you taken a look at the Data Validation dialog box and the Date criteria options?
Data Validation Examples
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks