Data Validation and Custom Number Formats

G

Guest

I have a cell with the custom number format of...
"Y";;"N"
I used data validation with "List" in Allow:, "0,1" in Source:, and I
checked "In-cell dropdown". I then put a message in both "Input Message" and
"Error Alert". When I select the value from the list everything works fine,
but when I type in 1 or 0 I get the error alert message. I deleted the
custom number formatting and the data validation works fine both ways. Is
there something I'm missing here, or this a bug?
 
G

Guest

While I didn't find the reason of the error I did find a workaround. I used
a two cells containing 0, and 1 as the source. This allows me to both select
from the list, and type in the numbers.
 

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

2007 data validation not working 1
Data validation error message 3
data - validation - list question 2
Data Validation error 2
Data validation with custom number formatting 1
Urgently help needed - dropdown box does not show up 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
If formula and Data Validation parallely 1

Top