If Dick has provided a useful answer, then the answer to my question was
no - I am using a reference to a range.

--
Regards,
Tom Ogilvy

"Mike" wrote in message
...
Tom
Thanks for responding. Yes, the data set has the values listed in 0.1
increments.
Another strange aspect is that it will allow entries of 1.2 and 1.3 as
well as 0, 0.1 and 0.2.
But no other entries are allowed if manually typed in.
The only way to enter any other values from the data validation list is
though the cell drop down list.
I am completely confused.
Mike

----- Tom Ogilvy wrote: -----

in the validation list textbox you have this listed like
0.0,0.1,0.2,0.3,0.4
all the way up to 40.0?

--
Regards,
Tom Ogilvy


"Mike" wrote in message
...
I hope 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 picking
a value from the drop down list or manually type a value that is on
the
data validation list. My purpose is to avoid
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 is
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 down
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 message
even though they are on the validation list.
I am confused over this. Can anyone help?