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.