Custom Data Validation Problem

[LeighAnne]

I am having a problem creating a formula when using custom in data validation. I want the entry in the cell A9 to be restricted to a 6 or 7 digit number or the text "O/H".

I am using the following formula but it currently evaluates to an error:

=OR(A9="O/H",AND(A9>=100000,A9<=9999999)

Can anyone help?

 

[xlbo]

you WILL kick yourself:

=OR(A9="O/H",AND(A9>=100000,A9<=9999999))

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[LeighAnne]

Nooooooooooooooooooooooooooooo!

Self now seriously kicked!

Cheers Geoff!

 

[xlbo]

LOL

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question