DATA VALIDATION
Format the cell, custom number format as 00 (I am assuming you always want
the preceding 0 to be shown for 03-09.
Data|Validation
Allow: Whole Number
Data: Between
Minimum: 3
Maximum: 83
Hope this helps.
--
John C
"William" wrote:
xp/2003
I am trying to specify that fields in a column can only accept an entry
between 03 and 83 and that each entry have two and only two numbers (03-83,
in other words). The entries can be either number or text format.
I can't find the combination of cell format and data validation that allows
this.
Ideas?
--
William
|