Data Validation

[Duncan]

Hi all,

a really picky question, why does the data validation allow a space
after the list value?


for instance, I have data validation to allow "yes" or "no" and I have
some other sumproducts looking to these cells to give me figures, but
it will allow you to put "yes " or "no " which the sumproduct wont pick

up with the blank space in.


can this be prevented? and why does it allow the blank space?


Duncan

 

[Duncan]

I am trying to post a new topic but it keeps replying to this thread
instead!.

sorry,

ill try again

Duncan