» 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:
- Microsoft Windows XP Registry Guide
- A Mathematician Plays the Stock Market
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Marketing Planning for Services
- Special Edition Using Microsoft Access 2002
- Investments + S&P Card + Powerweb + StockTrak discount coupon
No comments have been submitted.
