How can I set property of cell so that only Integer input can be given in a
Cell.

Data Validation Allow Value 'Whole Number'
Regards,
Alan.
"HUNTER" wrote in message
...
How can I set property of cell so that only Integer input can be given in
a
Cell.

Hunter, one way, data, validation, allow, whole number, put in a min and max

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"HUNTER" wrote in message
...
How can I set property of cell so that only Integer input can be given in
a
Cell.