Thanks:  0
Likes:  0

Thread: How can I put dash in Data Validation

1. I want ot use Data Validation in Cell but my problem is , I want to put "-" in cell also but it not work with Data Validation Assume. I want number 1 to 14 to put in Cell and I want "-" (dash) to put also ( dash putting like no data )

2. I'm afraid you have lost me. Could you give a relavant example?

3. Example. in Cell A1 ,The User should puting number 1 - 14 or put - (dash) in Cell A1 ,How can I do this with Data Validation (I use Criteria-Whole number ; number 1 - 14 is accept ,but -(dash) not accept by Data Validation. How can i do this or I have to choose another criteria ?

4. Could you place all possible numbers is a list and Then use the "LIst' criteria?

5. Yes , that Idea it work but acctually my number is 1-99999 so its a lot to putting is list . Do you have other Idea ? Thanks.

6. On 2002-03-12 04:40, Anonymous wrote:
Example. in Cell A1 ,The User should puting number 1 - 14 or put - (dash) in Cell A1 ,How can I do this with Data Validation (I use Criteria-Whole number ; number 1 - 14 is accept ,but -(dash) not accept by Data Validation. How can i do this or I have to choose another criteria ?
If you can manage using -9 instead of a - (dash), you can set up a 'custom' data validation in A1, where the formula below will do what you want:

=AND(ISNUMBER(A1),OR(A1=-9,AND(A1-INT(A1)=0,A1>0,A1<100000)))

7. On 2002-03-12 04:07, Anonymous wrote:
I want ot use Data Validation in Cell but my problem is , I want to put "-" in cell also but it not work with Data Validation Assume. I want number 1 to 14 to put in Cell and I want "-" (dash) to put also ( dash putting like no data )
If you custom format the cell so that zero is formatted as a "-", you can then data validate between 0 & 14, but the user will have to enter 0 rather than "-". Is this acceptable, or must the user enter a "-"?

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•