Under Data Validation, Custom - In formula Box enter:
=AND(A10,A1=INT(A1))
Jim May
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
:
Data Validation is pretty easy. Have you looked?
Would you say that an integer is a "whole number"?
If you are looking for a positive integer, would that be "greater than"
zero?
--
David Biddulph
"Momma Jay" <Momma wrote in message
...
I have to enter rules for data for a cell that must have settings for
"positive integers" This is my first time using Excel. Any help would be
appreciated.