Input Mask

Closed
-
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
-
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
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
491
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