» Validating text entries in Microsoft Excel
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
From Data choose Validation.
The Allow box in the Settings tab does not include criteria for validating text.
You can validate a text entry, but you cannot check whether the entry is text or not.
Solution: Enter a formula that will check whether the data is text.
- Choose Data, Validation.
- Select the Settings tab.
- In the Allow box, select Custom.
- In the Formula box, enter =IsText(D4) (D4 is the first cell in the range).
- Click OK.
Book Store:
Recommended Books:
- Microsoft Windows XP Registry Guide
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The 22 Immutable Laws of Branding
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Dictionary of Finance and Investment Terms
- Microsoft Office XP Step-By-Step (With CD-ROM)
No comments have been submitted.
