Now, let’s insert the data validation control. Using the simple demonstration sheet shown in Figure A, click B2. Feel free to use one of your own files if you like or choose another cell.

Figure E Data validation rejects this input value because it contains a non-numeric character. Entering 12345678 and 12345678901 will also fail data validation.