Validation

[Paul W Smith]

I want to restrict data entry to a cell to be only "Y" or "N".

Using Validation I can achieve this, Stopping any other numbers or letters,
but not apparently symbols. "*" is still allowable.

Any ideas anyone?

PWS

 

[Peo Sjoblom]

Not if you use allow>list, in the list source box put Y,N
and uncheck in cell dropdown

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom