Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set an Input Mask with Data Validation??
I want to set data validation on cells to only allow:
C-###-#####-#### (# is any digit) Is there a way I can use the equivalent of an Input Mask, or do I have to write a big long formula? Thanks Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set an Input Mask with Data Validation??
I can't think of anything that supports this without a formula, but try this
one with Data=Validation, Custom =AND(LEFT(A1,1)="C",LEN(A1)=16,ISNUMBER(SUBSTITUTE (RIGHT(A1,14),"-","")*1),L EN(SUBSTITUTE(RIGHT(A1,14),"-",""))=12) -- Regards, Tom Ogilvy "Rob" wrote in message ... I want to set data validation on cells to only allow: C-###-#####-#### (# is any digit) Is there a way I can use the equivalent of an Input Mask, or do I have to write a big long formula? Thanks Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to format data with an input mask like ss# (***-**-****) | New Users to Excel | |||
Data Validation and Input Mask | Excel Discussion (Misc queries) | |||
Data Validation-Input Mask | Excel Discussion (Misc queries) | |||
Input Mask | Excel Programming | |||
Mask input in input boxes? | Excel Programming |