Peo ... (Good morning)

"List" ... P,1,2,3,4,5,6,7,8 ... is also allowing decimals such as 1.5 to be
entered?

Am I missing something? ... Thanks ... Kha

"Peo Sjoblom" wrote:

That won't prevent anyone entering 1.5 for instance and the UPPER part is
moot, you can use

EXACT(A1,"P")



--


Regards,


Peo Sjoblom




"muddan madhu" wrote in message
...
Suppose u want validation for A1 cell,
Use custom validation and put this formula =OR(EXACT(A1,UPPER("p")),
(A1=1)*(A1<9))



On Jun 4, 7:08 pm, Ken wrote:
Excel2003 ...

Need Formula in "Validation" that will allow input of:

Capital Letter "P" and any "whole" number between 1 & 8.

Thanks ... Kha