this is bound to be a really simple answer, but I can't find it.
I want to stop users from entering just a 'space' character in a cell using data valdiation, but it doesn't seem to have an option for 'not equal to'. I'm happy for them to enter text or numbers.
Can anyone please put me out of my misery on this one?
Forgot to say, this is in 2007
Last edited by BillDoor; 08-30-2013 at 09:08 AM. Reason: update
In Data Validation select Custom in Formula enter "=" and check "Apply these setting to all other cells"
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
That restricts them from entering anything.Originally Posted by AlKey
To only prevent them from entering a space, use this formula:
=IF(A1=" ",FALSE,TRUE)
When I say semicolon, u say comma!
thanks all, I've also stubbled upon using this -
=A1<>" " as the formula in validation
Ok, this seems to be working to prevent entering "=" and allow any other will go in.
Use formula below and format validation cell(s) as text.
=ISERROR(FIND(CHAR(61),A1))
Last edited by AlKey; 08-31-2013 at 01:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks