| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation rule - custom 5 digits w/ leading zeroes
First change the cell to format--Text
Then under data-- Validation select custome from drop down choices and enter =len(trim(a1))=6 Now cell A1 will only accept texts = 6 characters If you need space as a character then remove "trim" from the formula "jennifer" wrote in message ... 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
