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.