i have cells D22:D36 with validation from N1:N1000. in that N column, there are codes for products. it is really strange because the majority of product codes you can type into the cell no problem, but there are certain product codes that you cannot type into the cell but when you try to bring them up from the dropdown list they will work? i can type 3-3037 in the cell and it comes up erroe, but i pull that code up and it goes in the cell? it is really racking my brains, any ideas why or what i would have to do?

thanks