How to control the length of input data in excel?
Wet blue shirt with tears 2020-11-25 19:45:38
When you do some statistical forms that require you to fill in the information together , For the standardization of data , You can set the character length of cell input data in advance , For example, when you enter your ID card number. , The input length must be 18 position , In this way, if the number entered by others is not enough 18 Bit or greater than 18 No one can do it . So how to operate ?

Excel How to control the length of input data ?

Tools / raw material


The computer ( Any model will do )

Excel( The version used in this case is Excel 2016)

Example title


As shown in the figure below , You need to input your ID card number in the form. , Now set it up in advance E The character length of the data that can be entered in a column cell :

Excel How to control the length of input data ?

Methods and steps


step 1、 Select the cell area that needs to fill in the ID number. , As shown in the figure below E2:E18 Cell range , The operation is shown in the figure below :

Excel How to control the length of input data ?


step 2、 choice 【 data 】, And then choose 【 data validation 】, The operation is shown in the figure below :

Excel How to control the length of input data ?


step 3、 stay 【 data validation 】 Select in the dialog box 【 permitted 】 by 【 Text length 】, The length is set to 【 be equal to 】【18】, The operation is shown in the figure below :

Excel How to control the length of input data ?


Excel How to control the length of input data ?


step 4、 stay 【 Error warning 】 Interior selection 【 stop it 】, Then type in the error message “ Please enter 18 I. D. number !”, The operation is shown in the figure below :

Excel How to control the length of input data ?


step 5、 Now, you can verify the return , stay E Column random number of digits , It will prompt the error . The operation is shown in the figure below :

Excel How to control the length of input data ?


summary


step 1、 Select the cell area that needs to fill in the ID number. , As shown in the figure below E2:E18 Cell range

step 2、 choice 【 data 】, And then choose 【 data validation 】

step 3、 stay 【 data validation 】 Select in the dialog box 【 permitted 】 by 【 Text length 】, The length is set to 【 be equal to 】【18】

step 4、 stay 【 Error warning 】 Interior selection 【 stop it 】, Then type in the error message “ Please enter 18 I. D. number !”
版权声明
本文为[Wet blue shirt with tears]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/20201125194407963z.html
相似文章

2021-08-09