| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
simple validation formula required
can anyone pls help me with a simple validation formula I require.
I need to restrict entry into a cell for just 5 numerical digits (no alphabetic characters) i use the LEN function to make sure that the number of digits is exactly equal to five, but don't know which function to use to restrict alphabetic and other characters. please help thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Scroll in the formula bar for a custom criteria | Excel Worksheet Functions | |||
| help please with simple formula | New Users to Excel | |||
| HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions | |||
| simple formula with blank cells | Excel Worksheet Functions | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
