Look at data validation http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kim-Anh Tran " wrote in
message ...
How do I set a cell validation_ setting to custom only allowing "A"
entry?
Thanks in advance for your help!


---
Message posted from http://www.ExcelForum.com/