That's because of how our system was set up. I agree with you that it would
be easier to order units instead of pieces.



"JE McGimpsey" wrote in message
...
You've gotten an accurate answer, but for the convenience of your users,
why don't you just let them order by the dozen (i.e, 1,2..., instead of
12,24...)
?



In article ,
"JMM" wrote:

I am creating an order form in which I have cells that are used to enter
a
certain quantity of pencils. The pencils must be ordered in multiples of
12.
How can I use Data Validation to check if the ordered quantity is always
a
multiple of 12?