limit choice in cell to one of two values;

[Guest]

I have a cell where I want the user to ONLY to be able to
input the number "1" or "4".

Any help out there?

 

[Otto Moehrbach]

Use Data Validation. Select List and type 1,4. HTH Otto

 

[Guest]

Data, Validation, List

1,4

http://HelpExcel.com

 

[JE McGimpsey]

Check out Validation in XL Help.