Quote Originally Posted by Marcol View Post
Try this
Data Validation > Custom
Formula:=
=AND(ISTEXT(LEFT(A2,3)),SEARCH("-",A2,1)=4,ISNUMBER(RIGHT(A2,6)*1),LEN(A2)=10)

Hope this helps

Thank you for the suggestion. When I use this, it still allows me to put other data in there that is not formated. So I could just type NEW in there and it would not error off, which is what I would have thought data validation should do in this case.

If users are not forced to enter all three letters, AND all 6 numbers, we will always be sending the form back to them to enter it correctly.

Maybe I was doing something wrong that it allows incorrect formats to be entered.
Thanks again for your help.