istext() in data validation

[lezawang]

Hi
I want to make sure column A1:A10 user can only enter text. So with your help, thank you, now I understand I need to create custom data validation and the fomula is

istext(A1)

How to understand this? It is working but lets say I enter a text A1=hello then istext(A1) will return TRUE which means apply Data Validation which means excel will give error message My understanding that this type of DV will be executed if the formula is true. AmI right? Thank you so much

Wanted add.. same idea I prevent duplicated values I use =countif(range, A1)

if countif is true then I stop

 

[Scott Huish]

Data Validation will give an error if it is FALSE

What you are trying to do is specify a condition that will be TRUE if you are entering an allowable value.