Hi, everyone.
This should be simple, but it's escaping me. I want to put validation on a cell in the form of a pick list. However, my items to pick from are 5/10, 10/5, 11/5, 5/11, etc. The problem is as soon as I type those into the list, Excel changes them to dates. I don't want that. How do I force the validation to use the text I give it? Please bear in mind that I am populating this list through a macro and cannot reference a range of cells which I know would solve my problem. Any ideas?
Cheers,
JJ