Forum Discussion
Jaime_Lynn
Sep 01, 2022Copper Contributor
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...
- Sep 01, 2022
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
DexterG_III
Iron Contributor
Jaime_Lynn My apologies for not reading closely enough.
Jaime_Lynn
Sep 01, 2022Copper Contributor
No worries! 🙂