Thread: DATA VALIDATION
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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