» 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:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Accounting for Dummies
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Financial Statement Analysis with S&P insert card
- Microsoft Windows XP Inside Out
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
No comments have been submitted.
