| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell that only a certain number may be entered
I need a cell to allow only a certain number to be entered such as a 2 or a 0.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell that only a certain number may be entered
Use Data Validation.
-- Gary''s Student "jbailey" wrote: I need a cell to allow only a certain number to be entered such as a 2 or a 0. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell that only a certain number may be entered
I tried that but it still accepts a different number such as 1
"Gary''s Student" wrote: Use Data Validation. -- Gary''s Student "jbailey" wrote: I need a cell to allow only a certain number to be entered such as a 2 or a 0. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell that only a certain number may be entered
How about DV and Custom =A1=2
Only the number 2 is valid entry for A1. Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 10:14:02 -0700, jbailey wrote: I tried that but it still accepts a different number such as 1 "Gary''s Student" wrote: Use Data Validation. -- Gary''s Student "jbailey" wrote: I need a cell to allow only a certain number to be entered such as a 2 or a 0. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell that only a certain number may be entered
How would I then tell it that either 0 or 2 are valid?
"Gord Dibben" wrote: How about DV and Custom =A1=2 Only the number 2 is valid entry for A1. Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 10:14:02 -0700, jbailey wrote: I tried that but it still accepts a different number such as 1 "Gary''s Student" wrote: Use Data Validation. -- Gary''s Student "jbailey" wrote: I need a cell to allow only a certain number to be entered such as a 2 or a 0. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell that only a certain number may be entered
=OR(A1=0,(A1=2))
Gord On Thu, 24 Aug 2006 12:31:02 -0700, jbailey wrote: How would I then tell it that either 0 or 2 are valid? "Gord Dibben" wrote: How about DV and Custom =A1=2 Only the number 2 is valid entry for A1. Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 10:14:02 -0700, jbailey wrote: I tried that but it still accepts a different number such as 1 "Gary''s Student" wrote: Use Data Validation. -- Gary''s Student "jbailey" wrote: I need a cell to allow only a certain number to be entered such as a 2 or a 0. Gord Dibben MS Excel MVP |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell that only a certain number may be entered
that will work for the 2 but how do I make it accept both the 2 and the 0
"Gord Dibben" wrote: How about DV and Custom =A1=2 Only the number 2 is valid entry for A1. Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 10:14:02 -0700, jbailey wrote: I tried that but it still accepts a different number such as 1 "Gary''s Student" wrote: Use Data Validation. -- Gary''s Student "jbailey" wrote: I need a cell to allow only a certain number to be entered such as a 2 or a 0. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell that only a certain number may be entered
I already posted this earlier in response to your post but here it is again.
=OR(A1=0,(A1=2)) Gord On Thu, 24 Aug 2006 14:26:40 -0700, jbailey wrote: that will work for the 2 but how do I make it accept both the 2 and the 0 "Gord Dibben" wrote: How about DV and Custom =A1=2 Only the number 2 is valid entry for A1. Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 10:14:02 -0700, jbailey wrote: I tried that but it still accepts a different number such as 1 "Gary''s Student" wrote: Use Data Validation. -- Gary''s Student "jbailey" wrote: I need a cell to allow only a certain number to be entered such as a 2 or a 0. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| First Number in a Cell | Excel Worksheet Functions | |||
| Entered text value equals a number I specify in another cell | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
