How do I format a cell so that I can only input a Y or an N
I would like to configure a cell to give the data input person the coice of
"Y" or "N". How do I do this? |
How do I format a cell so that I can only input a Y or an N
Osacr, select the cell then data validation, settings, allow, list put Y,N,
set the other settings how you want and OK -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Osacr" wrote in message ... I would like to configure a cell to give the data input person the coice of "Y" or "N". How do I do this? |
How do I format a cell so that I can only input a Y or an N
Use Data Validation. See http://www.contextures.com/xlDataVal01.html
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Osacr" wrote in message ... I would like to configure a cell to give the data input person the coice of "Y" or "N". How do I do this? |
All times are GMT +1. The time now is 09:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com