How can I put dash in Data Validation

Mar 12th, 2002, 05:07 AM

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 )

Dave Hawley · Mar 12th, 2002, 05:13 AM

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

Mar 12th, 2002, 05:40 AM

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 ?

Dave Hawley · Mar 12th, 2002, 05:47 AM

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

Mar 12th, 2002, 05:54 AM

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.

Aladin Akyurek · Mar 12th, 2002, 01:18 PM

Quote:

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)))

Mar 12th, 2002, 02:11 PM

Quote:

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 "-"?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 05:07 AM	#1
Guest Posts: n/a	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 )

Mar 12th, 2002, 05:13 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	I'm afraid you have lost me. Could you give a relavant example?

Mar 12th, 2002, 05:40 AM	#3
Guest Posts: n/a	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 ?

Mar 12th, 2002, 05:47 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Could you place all possible numbers is a list and Then use the "LIst' criteria?

Mar 12th, 2002, 05:54 AM	#5
Guest Posts: n/a	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.