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.
Bookmarks