Home |
Search |
Today's Posts |
#1
|
|||
|
|||
input masks and validation
when entering data in a cell, i need to restrict users to enter the following
alphanumeric combination and nothing more. "aa####a", where "a" is an alphabetic character (a-z) and "#" is a number (0-9) i cannot figure out the formula to use under the 'custom' section of Data - Validation pls help! thanks |