Restricting Cell Entries to Text Only
We want to ensure that only text may be entered into the cells of column A.
Use Data Validation:
1. Select Column A.
2. Data Data Validation Settings Custom
3. Enter the following formula in the Formula box:
4. Click OK.
Thus, if an entry is not text, an error message will pop up, forcing the user to try again.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1