Input Mask

[Closed]
Report
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
Dear Sir/Maddom.

Hope to be fine and doing well.

first of all i am thanks from your services in the filed of IT.

I am working in Telecom Company Distribution Channel so we entry all the Form Number in Excel some time we entry more and less after that i check by =len() Formula help remove the more number so how i can use the formula which not let me to entery more or less number in a excel cell.

thanks





1 reply

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Hi babakarkhail,

With the Data Validation option found under the Data ribbon, you can enter a minimum and maximum amount to be entered in the cell. So no need for formula here.

Best regards,
Trowa