limit choice in cell to one of two values;

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?

[JE McGimpsey]

Check out Validation in XL Help.

In article <009701c515f9$0e5727c0$a401280a@phx.gbl>,
<anonymous@discussions.microsoft.com> wrote:

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

[Otto Moehrbach]

Use Data Validation. Select List and type 1,4. HTH Otto
<anonymous@discussions.microsoft.com> wrote in message
news:009701c515f9$0e5727c0$a401280a@phx.gbl...
>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?

[galimi]

Data, Validation, List

1,4

http://HelpExcel.com

"anonymous@discussions.microsoft.com" wrote:

> 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?
>