Specifying manually entered data validation list entries as "Text"
I have manually entered a data validation list directly into a cells Data Validation input box. The list contains the following items I've hand-typed into the list: 7/23, 5/1, 7/1, 10/1, 5/25. T...
I'd strongly recommend entering the list in a range; that is much easier to maintain.
But if you really prefer to specify it in the Source box, prefix each value with an apostrophe:
'7/23,'5/1
