Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to validate entries not to contain 00
Hi,
I need to be able to validate entries within a data range (H2:H1000). Within these cells I need to be able to put a limit that they must only have: 1) Four characters (Numeric if poss' to force by type as well) 2) End two characters must not contain 00. 3) Or they can be Null Is this poss' through data validation, or would this need to be done via VBA (trying to avoid VBA option if poss'). Cheers, Al. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to validate entries not to contain 00
Use DV with a formula of
=OR(H2="",AND(LEN(H2)=4,ISNUMBER(H2),RIGHT(H2,2)< "00")) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ... Hi, I need to be able to validate entries within a data range (H2:H1000). Within these cells I need to be able to put a limit that they must only have: 1) Four characters (Numeric if poss' to force by type as well) 2) End two characters must not contain 00. 3) Or they can be Null Is this poss' through data validation, or would this need to be done via VBA (trying to avoid VBA option if poss'). Cheers, Al. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
validate | Excel Discussion (Misc queries) | |||
How to validate | Excel Worksheet Functions | |||
How to validate entries with Data Forms in xls 2003? | Setting up and Configuration of Excel | |||
How to validate data entries to be unique within an array | Excel Worksheet Functions |