» Validating Number Entries
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To validate number entries: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 Whole number (or Decimal).
5. From the Data dropdown list, select Between.
6. In the Minimum box, enter the required lower limit, for example, 1000.
7. In the Maximum box, enter the required upper limit, for example, 9999.
8. Click OK.
Book Store:
Recommended Books:
- Financial Statement Analysis with S&P insert card
- The Interpretation of Financial Statements
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Absolute Beginner's Guide to Microsoft Excel 2002
- The Ernst & Young Business Plan Guide
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
No comments have been submitted.
