data validationgoogle sheets
I want to make a column (lets say column A) that you can only enter text into it, and reject all numbers.
I have tried "custom" and "=istext()" for the formula… other options don't seem to work
for example:
2 –> reject
hello2 –> accept
12 –> reject
one2one –> accept
If you prefix the data in the cell with a single quote—'—it should prevent any default formatting.
don't use it like this:
first, you need to create your custom list anywhere where it won't hinder you (like here on column G or even placed on hidden Sheet2):
=TRANSPOSE(FILTER(A2:E2, A2:E2 <> "no"))
and then you can create data validation from a range (G2:G in this case):
Best Answer
Try selecting ColumnA and for validation this formula: