Forum Discussion
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
Jaime_Lynn I think you were on the right track. Using the concatenate with null (&"") at the end of your formula will force everything to text.
=B2&"/"&C2&""
That particular response was referring to a list created by referencing cells. This particular thread is specifically talking about manually entering a list directly into the Source input field in the Data Validation dialog box.
Jaime_Lynn My apologies for not reading closely enough.
- No worries! 🙂
