DataValidationProblem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hoep someone can help with this "Mystery
My goal it to use data validation - list to allow an operator to enter a numerical value into a cell either by pickin
a value from the drop down list or manually type a value that is on the data validation list. My purpose is to avoi
the operator entering labels such as "77 years" instead of the number 77
I have one cell that the data list is 20 to 99. The operator can either enter from list OR type in whole value- there i
no problems with this cell accepting this
I have another cell that data list values are from 0 to 40 in 0.1 increments. I can pick a value from the drop dow
list BUT when manually typing a numerical value, I have a problem
I can enter ONLY the values 0, 0.1 or 0.2 and it will accept OK. But value higher such as 0.3, 1.2 give error messag
even though they are on the validation list
I am confused over this. Can anyone help?
 
Hi
this should work. Have you checked that they are included in your
source data list range?
 
Frank
Thanks for the response. Yes all values from 0 to 40 are included in the data set in incriments of
0.1. Another unusual aspect is that it will allow a value of 1.2 as well as 0, 0.1 and 0.2.
I completely at a lost to explain.
Mike

----- Frank Kabel wrote: -----

Hi
this should work. Have you checked that they are included in your
source data list range?
 
Assuming the list of values is entered on the worksheet, perhaps some of
the numbers are text, instead of real numbers. To convert them to
numbers, you can use one of the techniques shown here:

http://www.contextures.com/xlDataEntry03.html

For example:
Select a blank cell
Choose Edit>Copy
Select the cells that contain the numbers
Choose Edit>Paste Special
Select Add
Click OK
 
Thanks for the response
Tried exactly as you described but did not work
1 selected an empty cell and Edit -cop
Then I selected the data cell and did edit paste special , add and hit ok
But I still can only manually enter 0, 0.1 0.2, 1.2 and 1.3
Mik

----- Debra Dalgleish wrote: ----

Assuming the list of values is entered on the worksheet, perhaps some of
the numbers are text, instead of real numbers. To convert them to
numbers, you can use one of the techniques shown here

http://www.contextures.com/xlDataEntry03.htm

For example
Select a blank cel
Choose Edit>Cop
Select the cells that contain the number
Choose Edit>Paste Specia
Select Ad
Click O


Mike wrote
 
Hi Mike
this should work. If you like email me a file with these data
validation and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de
 
Fran
Thanks for the help offer but another person help me
He recommended to use the round function in my validation list lik
=ROUND(A1+.1,1)
this solved the proble

I wanted to share the answer that worked for me
Mik

----- Frank Kabel wrote: ----

Hi Mik
this should work. If you like email me a file with these dat
validation and I'll have a look at i
email: frank[dot]kabel[at]freenet[dot]d

-
Regard
Frank Kabe
Frankfurt, German


Mike wrote
 
Debra
Thanks for the help. Another person solved the problem for me by recommending
to use the round function on my destination list lik
=ROUND(A1+.1,1)
this solved my proble

I wanted to share the answer in case you have a similar problem in the future
Mik

----- Debra Dalgleish wrote: ----

Assuming the list of values is entered on the worksheet, perhaps some of
the numbers are text, instead of real numbers. To convert them to
numbers, you can use one of the techniques shown here

http://www.contextures.com/xlDataEntry03.htm

For example
Select a blank cel
Choose Edit>Cop
Select the cells that contain the number
Choose Edit>Paste Specia
Select Ad
Click O


Mike wrote
 
Back
Top