Allow only 10 digit numeric mobile number in Excel using Data validation

You want a column as 'mobile numbers' in your data and want to ensure only 10 digits and numeric values are entered. It shouldn't allow text values.
Use this Custom Data Validation technique to ensure your requirement is met. It uses a combination of LEN and ISNUMBER functions.
Play around with this method, to make your own Custom formula too!

For 1 more custom data validation technique, see

For more videos to learn excel, click this link

SUBSCRIBE!

Blog

Rushabh Shah is an expert in training Professionals & Students in Excel's Advanced features & formulas. These tutorials are simply a way to spread the knowledge and make people more productive using Excel.

For Classroom & Online Live Trainings with Rushabh, visit www.DLTC.co

[ManojGupta-nlfj]

Sir main ISI prakar ki tric ki Khoj mein tha bahut bahut dhanyvad iske liye

[mahamoudhassen]

i have searching for while and never seen as quick as simple you show, for that you have earned my subscribe and like hhh, anyway thank you very much

[saivinodh]

How to extract mobile no from each row and copy to the last cell in that row.

[emiliomarrello]

for North America thinking we use 123 456 7869 right-click, format cells, and number custom formatting works awesome. BUT how do I protect just his format for this cell so that my team does not use copy and paste and wipe out formatting? I want to protect data format but not lock out field for input

[sathishsunshine]

hi sir i love your videos. i have a question how to to alphabet and number total fixe by 20 nos only accept how to to

[deepakbhanushali]

if have applied this function to check for duplicate and text charactor no > 30

=AND(LEN(a2)<=30, ISTEXT(a2)), AND(COUNTIF($A$2:A7, A2)))=1
but this does not work

[xMazoJr]

What if the first digit is a 0? what do you have to do? apperently when i put 0 in the beginning, it does not count as a digit.

[mommypowerrr]

hey, i have special conditions for column in google sheets which are:
- should only be filled with numbers
- no special characters allowed
- no alphabets allowed
- no space allowed
- should be 16 digits in total

i tried using =AND(LEN(A2)=16, INT(A2)=A2) which works in excel, but strangely not in google sheets. oh i also notice that the 16th digits always change into 0 in excel. can you please help?

[kunalbajaj]

i forgot my number i know the last two digit how to find 1st eight number