View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Ansher.M@gmail.com is offline
external usenet poster
 
Posts: 1
Default Data Validation - Allow numbers, comma, - and space

Hello

I am trying to have data validation for a cell which only allows users
to enter numbers [0-9] , comma (,) , hyphen (-) and space. User should
be able to enter a combination of these characters.

For Eg: 3, 45-60

I have used this formula
=OR(F8=" ",F8="-",F8=",",F8="0",F8="1",F8="2").

But the problem with this is it allows as long as user enters any one
of these character, if they enter multiple it doesn’t allows them to.

Can anyone help me please?