Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Osacr
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format of a cell profG Excel Discussion (Misc queries) 1 January 16th 06 03:02 PM
Cond. Format & Absolute Cell Reference Question nastech Excel Discussion (Misc queries) 4 November 9th 05 05:02 PM
How do I change the format of a cell based on what I input? Husker87 Excel Worksheet Functions 8 August 19th 05 10:45 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"