ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   only INTEGER INPUT IN CELL (https://www.excelbanter.com/excel-worksheet-functions/125084-only-integer-input-cell.html)

Hunter

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

Alan

only INTEGER INPUT IN 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.




Paul B

only INTEGER INPUT IN 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.





All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com