Prev: Conditions Not Accurate when subtracting time
Next: Conditional Formatting with 3 Criteria Options
From: Ephraim on 18 Mar 2010 15:43
Hi,
I would like to ensure that a user can only input one of the following
numbers in a cell:
1, 2, 3, 4, 5, 6, 7 or 10

I'm using Excel 2003.

Thank you
Ephraim
From: Bob Umlas on 18 Mar 2010 16:30
Data/Validation
select List
enter:
1,2,3,4,5,6,7,10
Click OK.
You're done.
Bob Umlas
Excel MVP

"Ephraim" <rick.malone(a)gmail.com> wrote in message
news:b26e77d7-f5f6-4d44-ad39-813e357e1a7e(a)g4g2000yqa.googlegroups.com...
> Hi,
> I would like to ensure that a user can only input one of the following
> numbers in a cell:
> 1, 2, 3, 4, 5, 6, 7 or 10
>
> I'm using Excel 2003.
>
> Thank you
> Ephraim

From: Ephraim on 18 Mar 2010 16:48
On Mar 18, 4:30 pm, "Bob Umlas" <rum...(a)kpmg.com> wrote:
> Data/Validation
> select List
> enter:
> 1,2,3,4,5,6,7,10
> Click OK.
> You're done.
> Bob Umlas
> Excel MVP
>
> "Ephraim" <rick.mal...(a)gmail.com> wrote in message
>
> news:b26e77d7-f5f6-4d44-ad39-813e357e1a7e(a)g4g2000yqa.googlegroups.com...
>
>
>
> > Hi,
> > I would like to ensure that a user can only input one of the following
> > numbers in a cell:
> > 1, 2, 3, 4, 5, 6, 7 or 10
>
> > I'm using Excel 2003.
>
> > Thank you
> > Ephraim- Hide quoted text -
>
> - Show quoted text -

Is there a way to do it without using a dropdown list?
From: T. Valko on 18 Mar 2010 18:05
>Is there a way to do it without using a dropdown list?

Follow Bob's instructions but *uncheck* In-cell drop down.

--
Biff
Microsoft Excel MVP


"Ephraim" <rick.malone(a)gmail.com> wrote in message
news:fa50274a-be44-4166-8adf-6999cef12b78(a)o30g2000yqb.googlegroups.com...
On Mar 18, 4:30 pm, "Bob Umlas" <rum...(a)kpmg.com> wrote:
> Data/Validation
> select List
> enter:
> 1,2,3,4,5,6,7,10
> Click OK.
> You're done.
> Bob Umlas
> Excel MVP
>
> "Ephraim" <rick.mal...(a)gmail.com> wrote in message
>
> news:b26e77d7-f5f6-4d44-ad39-813e357e1a7e(a)g4g2000yqa.googlegroups.com...
>
>
>
> > Hi,
> > I would like to ensure that a user can only input one of the following
> > numbers in a cell:
> > 1, 2, 3, 4, 5, 6, 7 or 10
>
> > I'm using Excel 2003.
>
> > Thank you
> > Ephraim- Hide quoted text -
>
> - Show quoted text -

Is there a way to do it without using a dropdown list?


 | 
Pages: 1
Prev: Conditions Not Accurate when subtracting time
Next: Conditional Formatting with 3 Criteria Options