hello all,

i have problem with excel data validation.
when user type on validated cell it work successfully, but when user copy n paste from another cell, the data validation not working.

for example:
i have formatted cell A1 as number n set on data validation that
valid number is between 1 and 10.
when user type on cell A1, it work successfully, but if user copy value 'test' from another cell n paste it on cell A1, the data validation not working n cell
A1 which i have formatted as number before changed become text.



please help me to solve this problem.

thanks

Hi

When the user pastes a value he also pastes the format of the source cell so your data validation is erased.

You will need to use an input box or a form.