Data Validation
 

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.

Data Validation
 

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.

Data Validation
 

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.

Data Validation
 

Does that have any advantage over "Whole number" "greater than" 0?
--
David Biddulph

"JMay" wrote in message ...
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.