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.
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.