» Validating Text Entries
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:
=IsText (A1)
where A1 is the first cell in the range.
6. Click OK.
Book Store:
Recommended Books:
- Microsoft Word Version 2002 Inside Out
- Marketing Plan: A Handbook with Marketing Plan
- Accounting and Financial Fundamentals for Nonfinancial Executives
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Definitive Guide to Excel VBA
No comments have been submitted.
