Data Validation: Define Maximum Limit of Characters/ Digits in Cell

Hi All!

Below is the most popular way to define length limit for a cell, but it takes values besides from Min to Max limits when we paste values from the other cells to the range. Plz help!!
for example: In Column A —› Data Validation —› Settings —› Validation criteria —›

Allow: Whole number
Data: between
Minimum:1000
Maximum:99999999
Ok

(Set error message on Error Tab if required.)

now we've got a limit from 1000 to 99999999, and when we enter values manually it works, but if we try to paste any odd values like 123 or 467891233 etc. This validation doesn't work anymore, and accepts all the values. if it is not done, then wht codes are required for this operation? Plz help me out.

Thanks in Advance!!