I've set up a validation on a cell that only allows a certain list of items (project numbers) to be entered. If any number outside that list is entered I've set up an error message to pop up. The types of numbers in the list look like: 99127, 2001-271, 2002-124-2 etc. It's a long yet very exacting list. HOWEVER someone entered the following number and the cell validated even though its not found on the list... that number was 2001-*271 (note the asterist) Not this plays havoc with another database since this number is not truely a valid number. Is there some glitch with validation where *'s are conserned? I know that thay can be used for wild cards, but I do not want numbers like 2001-*271 to validate. Any Ideas out there?
Thanks
Lt. Krul.
Thanks
Lt. Krul.