Validation: allow only two numbers.

[JEM]

Cell starts off blank - I want users to enter only the numbers '0' or '20',
not the numbers between 1-19. Can this be done with Validation > Custom >
Formula?

Thanks.

 

[Frank Kabel]

Hi
enter the following formula in the validation dialog
(category 'custom') if you want to apply this rule for
cell A1:
=(A1=0)+(A1=20)

 

[xlbo]

You could also us
Data>Validation>Lis

Enter 0,20 in the "Source" bo

HT
Geoff