| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
Linear Mode
