Microsoft Office Tutorials and References
In Depth Information
Data Validation
Figure 9-10:
Excel warns
you if you
type invalid
data in a
cell.
Figure 9-11:
Define the
type and
range of
acceptable data
allowed in a
cell.
4. Click the Allow list box and choose one of the following:
Any Value: The default value accepts anything the user types
Whole Number: Accepts only whole numbers, such as 47 and 903
Decimal: Accepts whole and decimal numbers, such as 48.01 or
1.00
List: Allows you to define a list of valid data
Date: Accepts only dates
Time: Accepts only times
 
Search JabSto ::




Custom Search