Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format of a cell | Excel Discussion (Misc queries) | |||
Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
How do I change the format of a cell based on what I input? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |