Previous Topic Next Topic

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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

Input phone lock code
Lucas -
M.Mudasir -

3 responses
phone lock <SOS>
keary88 -
Ambucias -

1 response
input phone password
djzombo -
Rahul -

2 responses
Forgotten input phone lock code
jared -
closeup22 -

1 response
Can you rename the inputs on LG Smart TV (WebOS)?
sjdunning -
dhh1 -

4 responses