Forum Discussion
Solved
Data Validation in Excel
Hi there, I having a problem here. I want to apply data validation to some of the columns to only accept text. I have used the custom option and ISTEXT function. I then selected the columns. ...
Clerik_SSS Try the attached file. C2:D20 should only accept text.
Thank you for the response.
Your instruction is working. However, it is not taking text. When I write random words into these columns, I get an error message saying the value does not match the data validation set
Clerik_SSS Try the attached file. C2:D20 should only accept text.
- Many Thanks.