Thread: DATA VALIDATION
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default DATA VALIDATION

Hi

Data Validation Allow: "Whole number" Data: "Between" Minimum: 3
Maximum: 83 Ok

Format Number Custom Type : ##00 Ok


Apply theese to the cells desired.

Regards,
Per

"William" skrev i meddelelsen
...
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