Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Using Excel 2003's Data Validation feature (rather than VBA code), is it
possible to create an input mask? Specifically, I need to test for certain valid characters in a Project ID as follows: Example: PA264.04 Position 1: can be either a "B" or "P" Positions 2-5: can be either uppercase letters or numbers Position 6: must be a decimal point Positions 7-8: can only be numeric (00 - 99) Any help would be greatly appreciated. Thanks. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation-Input Mask | Excel Discussion (Misc queries) | |||
Input Mask for Dates | Excel Discussion (Misc queries) | |||
Input Mask | Excel Worksheet Functions | |||
input mask in excel | Excel Worksheet Functions | |||
Input Mask | New Users to Excel |