| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add extra space before comma | Excel Worksheet Functions | |||
| Inserting a space after a comma | Excel Worksheet Functions | |||
| Show comma in data validation list? | Excel Discussion (Misc queries) | |||
| Removing a space after a comma | New Users to Excel | |||
| HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) | |||
Threaded Mode
