New answers tagged data-validation
To allow text only select the Data tab from the ribbon and choose Data Validation and again select Data Validation. Change the Allow drop down to Custom and put this in the formula field: =ISTEXT(A2:A14) Put whatever cell range is relavant to you in the parenthesis. You can also create a custom error alert. To allow only numbers, repeat the steps ...
Top 50 recent answers are included