| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation
Hi,
How can i define the condition so that a user can enter the data in only the following format: AAAAA1111A, where "A" Represents any character & "1" represents any number. Sumit |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation
Sumit
See this search result from google. Validation is for Canadian Postal Code format. You should be able to adapt. http://snipurl.com/kz3j Gord Dibben Excel MVP On 21 Dec 2005 07:23:50 -0800, "Sumit" wrote: Hi, How can i define the condition so that a user can enter the data in only the following format: AAAAA1111A, where "A" Represents any character & "1" represents any number. Sumit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Data Validation | Excel Worksheet Functions | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
