|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Data Validation > Restrict to Text | < Previous | Next > |
Step 1 - Highlight the cells |
 |
Step 2 - Enter the Criteria |
You can validate for only text by choosing "custom" in the Allow box and entering the formula "=ISTEXT(A1)". |
 |
Press OK to apply the data validation. |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | < Previous | Top | Next > |