Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to set data validation on cell that display a date in Excel?
I have a cell where user should enter a date in the format "mm/dd/yy" so I
formated the cell to do so. when user enter a diffrent date format, the OS convert it the predifined cell formating. but when an illogical entry is made no thing happends. does data validation allow me to do so and dispaly a warning message and how can I do so? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
how can i display the date and time of a cell entry in excel? | Excel Discussion (Misc queries) | |||
Data Validation lists display bottom vs top | Excel Discussion (Misc queries) | |||
Display cells with data validation | Excel Discussion (Misc queries) | |||
Exporting from MYOB to Excel the date cell doesn't display as dat. | Excel Worksheet Functions |