I want to limit data entry in a range of cells to Y or N (Upper Case)
I have tried data validation, list, but this still allows y or n, I want just Y or N
I want to limit data entry in a range of cells to Y or N (Upper Case)
I have tried data validation, list, but this still allows y or n, I want just Y or N
Last edited by Paul Sheppard; 02-26-2009 at 06:12 PM.
Paul
Try Data Validation: Custom:
=OR(EXACT(A1,CHAR(78)),EXACT(A1,CHAR(89)))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
i just tried it and used list ,in the list box type Y,N that only allows uppercase.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That is correct... I missed the part where the OP said list...
List is better, because you choose or type...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks