Data Validation

M

Momma Jay

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.
 
D

David Biddulph

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?
 
J

JMay

Under Data Validation, Custom - In formula Box enter:

=AND(A1>0,A1=INT(A1))

Jim May
 
Top