| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
custom validation with number & text
how can i write formula for custom validation for a cell like this.
first 3 digit shoulg be a number, next digit should be a text then next 6 digit should be number. e.g. 126P151008 thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom validation number and text | Excel Discussion (Misc queries) | |||
| Custom Data Validation for specific text and numbers only | Excel Discussion (Misc queries) | |||
| Data Validation and Custom Number Formats | Excel Discussion (Misc queries) | |||
| Data validation with custom number formatting | Excel Discussion (Misc queries) | |||
| Custom Number Format Text | Excel Discussion (Misc queries) | |||
Threaded Mode
