Input Mask

Closed
babakarkhail - Aug 9, 2015 at 01:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 13, 2015 at 11:30 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 13, 2015 at 11:30 AM
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
0