Cell Value Validation

[mattie]

Hi

I have a cell that users put thier employee number in. This number starts with a letter then 5 numbers, i am trying to build some valdiation in a cell so that it throws up an error message if the value is in that cell isnt in that format.

can anyone help

thanks!

 

[Jon von der Heyden]

Data Validation > Custom:

=AND(CODE(UPPER(LEFT(A1,1)))>64,CODE(UPPER(LEFT(A1,1)))<91,--MID(A1,2,255),LEN(A1)=6)