Only allowing certain inputs into cells

  • Thread starter Thread starter David C. Glasgo
  • Start date Start date
D

David C. Glasgo

I have a whole list of cells that formulas calculate off
of that are based on 3 entrys into the cells.

Either a -, 0, or 1.

Is there a way to set the cell so that only one of those 3
characters can be entered? and if so, how do I do that?

Thanks greatly.
 
Hi David

Use Validation from the Data menu. "Allow" List, "List source" (write this:) "a-",0,1
 
Hi David,

Select the desired cell. Goto Data>Validation.
Allow>Custom
Formula =OR(A1="-",A1=0,A1=1)
Select an input or error message if desired
OK out

Biff
 
Create a list of the 3 values that you want to restrict
entry access
A1="-"
B1="0"
C1="1"
Select "Data" and then select "Data Validation"
Under the Settings tab select "List" in the "Allow" option
box
Under the Source option box select $A$1:$A$3 to represent
the list, you have the option of entering Input message s
as well as error message, depending upon how detailed you
want to get...
 
Back
Top