Thread: Data Validation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 422
Default 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.