max and min and numbers

[JcR]

If possible, how do I require:
1) Maximum numbers entered into cell is 3
2) Minimum numbers entered into cell is 3
3) only numbers are eneterd into cell

Thanks

 

[Ron Coderre]

I think Data Validation will get you where you want to be.

If you have questions, check Debra Dalgleish's Contextures website:

http://www.contextures.com/xlDataVal01.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[L. Howard Kittle]

Data > Valadation > Allow > Whole number > Between > 100 > 999 > OK

HTH
Regards,
Howard