| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation rule - custom 5 digits w/ leading zeroes
I am having trouble creating a validation rule for cells. I would like only
6 digit numbers to be entered. However, when using CUSTOM (000000) I can't seem to get it to work. Any thoughts? 012345 234567 It works for 234567 but not for 012345 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Custom | Excel Discussion (Misc queries) | |||
| Using custom functions within custom validation | Excel Discussion (Misc queries) | |||
| CSV leading zeroes | Excel Discussion (Misc queries) | |||
| Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
