max and min and numbers
 

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

Thanks

max and min and numbers
 

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


"JcR" wrote:

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

Thanks

max and min and numbers
 

Data Valadation Allow Whole number Between 100 999 OK

HTH
Regards,
Howard

"JcR" wrote in message
...
If possible, how do I requi
1) Maximum numbers entered into cell is 3
2) Minimum numbers entered into cell is 3
3) only numbers are eneterd into cell

Thanks