Is there a way in data validation not to allow the letter "O" to be
contained? Also I need it to be no more than 5 characters and/or numbers.

This is an employee number that is 5 characters, but never contains the
letter "O". I do not want the user to mistakedly type in "O". I need it to
prompt that they must use the number "0".

Thanks in advance.

Try this:

Custom, and enter this formula:

=AND(LEN(A1)=5,ISERR(SEARCH("o",A1)))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jhicsupt" wrote in message
...
Is there a way in data validation not to allow the letter "O" to be
contained? Also I need it to be no more than 5 characters and/or numbers.

This is an employee number that is 5 characters, but never contains the
letter "O". I do not want the user to mistakedly type in "O". I need it
to
prompt that they must use the number "0".

Thanks in advance.

One way, assume number is in B1, in validation use custom and

=AND(LEN(B1)5,ISERR(SEARCH("o",B1)))


--
Regards,

Peo Sjoblom

(No private emails please)


"jhicsupt" wrote in message
...
Is there a way in data validation not to allow the letter "O" to be
contained? Also I need it to be no more than 5 characters and/or numbers.

This is an employee number that is 5 characters, but never contains the
letter "O". I do not want the user to mistakedly type in "O". I need it
to
prompt that they must use the number "0".

Thanks in advance.

Thanks - it worked perfectly!

"Peo Sjoblom" wrote:

One way, assume number is in B1, in validation use custom and

=AND(LEN(B1)5,ISERR(SEARCH("o",B1)))


--
Regards,

Peo Sjoblom

(No private emails please)


"jhicsupt" wrote in message
...
Is there a way in data validation not to allow the letter "O" to be
contained? Also I need it to be no more than 5 characters and/or numbers.

This is an employee number that is 5 characters, but never contains the
letter "O". I do not want the user to mistakedly type in "O". I need it
to
prompt that they must use the number "0".

Thanks in advance.