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?