Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation on a custom format
Hi again everyone....
I am currently using the following custom format: [h]:mm How can I use data validation to prevent invalid data from being entered into a cell of that format?? For my purposes, I only want data which consists of 1 or more digits in the "hours" field, folowed by one colon, followed by 1 to 2 digits in the minutes field. Do I need to enter some sort of formula into the data validation field?? thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
custom data validation | Excel Worksheet Functions | |||
Custom function valid in Data Validation/Conditional Format? | Excel Programming | |||
Custom Format and Data Validation Q | Excel Worksheet Functions |