Hello
I have this excel sheet set to accept certain values only through the data validation field set to accpt only these values only
1, 20, 35

however i seem to be able to set the values through VB by unprotecting the sheet.

when i go back to excel, the value say 60.001 is there, however, data validation still says i can only have 1,20 or 35

is my vaue 60.001 written to the cell valid or does it have limitations?