Data validation question

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi

I have a cell that contains a data validation field. The entries of the
dropdown box are "yes" and "no". Now I have the problem, that I want to
enter just the first character of the desired value, e.g. "y" for "yes". Is
it possible to get this work? It seems that Excel doesn't support this
feature. Many thanks in advance.

Tom
 
If you mean you want to enter Y and have Yes appear in the cell, or Yes to
be highlighted in the list, then no, data validation doesn't support that.
 
Tom,

I don't think you can do this. If it is a straight YES/NO field, then you
could put Yes/No as a header and enter y & n as the list data.

Steve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A data validation question 1
get Data Validation to stop, list supplied, duplicate data entries 1
Data Validation & multiple columns 6
Alternative to Data Validation (List) 3
Data Validation 1
Data Validation List (conditional) 2
Data Validation - copy/paste 3
Data Validation 4

Back
Top