Mobile Number Validation for 10 Digit│MS-Excel Phone Number Validation Formatting in HINDI
HTML-код
- Опубликовано: 20 авг 2024
- This video will show you how to apply for Mobile number validation in MS-Excel to get only 10 digits, not more than 10 and not less than 10.
with this method or trick, you could Enter Mobile number only in Excel cells whereas you need to enter a Mobile number.
this is very simple and Easy technique, everyone should know this.
This entire method is based on Data validation and whole number validation where we need to enter a minimum and maximum value for Mobile number. Please Enter below value in minimum and maximum.
(10 Digit ) Minimum: 1000000000 (if Your mobile number is for 10 Digit)
(10 Digit) Maximum: 9999999999 (if Your mobile number is for 10 Digit)
when your mobile number or phone number is 10 Digit, then use 10 digit mobile number trick otherwise use digit depends on your mobile number digit.
if this trick not working, then you may use below next method with custom validation rather than any value and Whole Number.
Apart from your custom cell formatting, you could use Data Validation with this rule...
=LEN(cell-ref)=10
This will then not allow you to enter anything in that cell that is not 10 characters
=LEN(B10)=10
If you add this, it will then only allow numeric entries, and not allow any text
=AND(ISNUMBER(B10),LEN(B10)=10)
Let's see in this Video how to do this trick for Phone number,
and our More Video....
BHIM UPI APP Download And full Tutorial, !! Unified Payments interface Bank App !! - INDIA
• Video
How To USE WhatsApp New STATUS - HIDDEN FEATURES FULL IN HINDI Tutorial
• Video
How to SAVE RUclips VIDEOS in Mobile Gallery By Changing URL (Only 3 Step)
• Video
How to Recharge With PAYTM and FREECHARGE: Full HINDI TUTORIAL step by step
• Video
LIKE | COMMENT | SHARE | SUBSCRIBE
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
www.youtube.co....
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u
Music: www.bensound.com
~-~~-~~~-~~-~
Please watch: "Formatting in MS-Excel For Beginners- !! Hindi PART 2 !! A Comprehensive Guide for Everyone"
• Formatting in MS-Excel...
~-~~-~~~-~~-~
Thank you sir
Thanks, Very useful
How to validate for column numbers entered already?
Sir Excel me mobile number add kese kare jo Easy way ho ,aur mobile number likhe to Person ka name likhi hue sari detal mil jaye.
It will allow text also need to allow only numbers
Agar 3 column hai or usme sirf number value likhani hai ok
To agar koi text likhe to wrong kese bataye
Konsi formula use kar sakte hai
Sir mobile phone number humara ek shell me hei . hum kaise number ko 10 column me (ek colum shell me sirf 1 digit rahega ) add karenge ?
Full help full video
thanks mehuna
Bhai muje mobile shop ke liye tebal chahiye
Table mei apki kya requirements hai uske according heading daale aur entry start kar de
sir mere pass bhut bada data hai or usme se mujhe kewal 10 digit hi rakhne hai or baki ke nahi chahiye kese kare
Sir, 10 disit feed ho & double number feed nhi ho ke bare video banyen pl
sir company me salary sheet kaise banai jati hai,plz vedio
salary sheet ke liye mai new video bna dunga.
Sir please share two Excel sheet comparison formula
autometic 10number enter hone par next colum me kayse karege
next column mei Maine len ka formula lagaya hai....
usse length calculate hoti hai.
How to know a wrong sentence in this column?
this is not to find the wrong sentence in the column this only is condition formatting.
Sir mujhe daraz .pk app pe account banakar order karna tha but ban nhu rha h jaise hi apna phone number enter Karen ke bad send karte h otp code k liye to enter valid phone number likh jata h to bataye kaise I'd banaye plz plz plz sir mujhe jaroorat h plz sir
Sir jaise no ha abc123456inko kaise short ya filter kare
how to get telephone network name from first 4 digits of 10 in a column. please set a formula about multiple of 10 digits phone number and get operator name with first 4 digits. how we do this please make something a video.
अगर एक्सेल के कॉलम में मल्टीपल मोबाइल नंबर लिखे हुए है और अगले कॉलम में उसका नेटवर्क नाम आ जाये सिर्फ पहले 4 डिजिट्स को रीड करके इसके लिए फार्मूला सेट करके बताइये जैसे 9694***** से idea, 6377****** से reliance आ जाये केवल फर्स्ट 4 करैक्टर को वह फार्मूला रीड करे और रिजल्ट दे देवे, ऐसा कुछ वीडियो हो तो शेयर करें।
Sri mujhe bhi shikan hay
Data feed krne ke baad kaise check ye batao , mobile number
Sir phone ma h phone numbers ka valid kar n ka video
Lookup,vlookup,hlookup smjh me aaye h pr jb krta hu to glti hoti h sir ....Help for it
aap please hamari vlookup series ki saari video dekhiye phir ho skta hai apka concept achce se clear ho jaye. aur apse phir koi galti na ho.
vlookup ki saari video apko playlist mei mil jaygi.
sir mera ek doc excel ha usme se mujhe bs mobile no niklna ha eska koe opsn ha toh bato sir
ya apka koi contact no ha toh bato pls i want arrgent
number se pehle +91 lagana aur htana please sir
concatenate se lagaye aur text to column se hataye.
Same number ko alag krane k liy bataiye
Adhar me minimum number kaise lagane
अगर 10 से ज्यादा डिजिट लिखने हो तो
जैसे 12 डिजिट हो
तो min 100000000000 और
max 999999999999
लिखना होगा क्या?????
एकदम सही, 12 डिजिट के लिए 12 डिजिट का सबसे छोटा और बड़ा नंबर देना होगा
Sir AAP ne Jo mobile no ke sath me roa banani h wo kaise banani h jisme show ho rha h ki ye 10,9 h plz sir reply me
uske paas wale row mei maine len ka formula lagaya hai, =LEN(cell adress)
iss formule se apko character ka count milta hai jis cell ka adress aap denge uska.
uske baad maine uspr condition formating se color kiya hai ki agr value 10 se kam hogi to wo pink color ho jaye, simple.....
धन्यवाद भाई
Help sir
ha mai shikna chate hai
okay to hmare channel ko subscribe jaroor kare aur please video par comment karke btaye ki aap kya sikhna chahte hai.
Hlo sir muje excel k toolbar k sare view samjne hai like macro,and pls sare smza do
mai almost sabhi tool baar par video bna rah hoon, app mere sare video dekhiye.
agar uske baad kisi tool ko depth mei janna chahte ho to uss tool ya topic ko btao. mai uss par video jaroor banaounga.
thanks gurtej
Plz reply sir
Sir ye tarika GST no ke liye btao plz
Gst ke liye sabse pehle aap GST mei jitne digit hote hai utne digit ki small aur large number ke according condition lga sakte ho...
then gst number bhi enter kar skte ho.
Ager koi excel protect ho use kaise kholenge
excel sheet protect hai ya excel workbook.
Excel sheet
thik hai mai apko excel sheet protect karna aur usko unprotect karna sikhaounga.
Sir ye data validation mobile or Kyu open nhi hita