How to Add Zero 00 before Numbers in Excel | Add Leading Zero in Excel in Hindi

[@DevrajSingh-z9m]

Dear Sir, Your All Videos is very nice & very helpful all persons. So, Really Thank you so much Sir ji. I am so happy from your Videos.

[@dipak5651]

You always think from every angle and deliver the best methods. Thanks❤

[@Innozant]

Thanks.Krep Learning

[@krashnkant8858]

I have seen so many videos on youtube but no one has explained better than you.

[@Innozant]

Thanks Krishan ji ...Really means a lot to me dear..Happy Learning ♥️

[@HabibUllah-cw7do]

This is Habib from Pakistan, I just want to greet you every day, you are a fantastic teacher and a wonderfully humble man, God bless you....

[@Innozant]

Thanks Habib. happy Learning dear

[@rooneychauhan7718]

I saw many videos but this is the best of the best 👏👏👏👏👏 doing great job sir

[@amarjeetsingh8537]

Bahot sahi lagta hai apko concept samjhte dekh

[@Innozant]

Thanks Amarjeet ji for this valuable appreciation dear

[@RA-rh5lb]

Bahut badiya Sir ji. Thankyou

[@souravmishra689]

Your way of speaking is very nice. I got it.

[@Innozant]

Thanks Dear ❤️🙏

[@rajeevranjan2478]

Aap best ho sir

[@bikashbehera968]

Mind blowing teaching sir

[@motilalnehrupublicschool6978]

TOO GOOD. ALWAYS REQUIRED FOR CODING FOR PRE-BOARD EXAMINEE. 👍👍👍👍

[@rahulkumarsharma9533]

Saandaar video sir

[@Innozant]

Thanks Rahul

[@dhakafady774]

Love you sir thanks a lot sir

[@abhishekgupta-bp9ib]

jabardast sir.....

[@Innozant]

Thanks Gupta Ji

[@SUSHMAKUMARI-q9l]

Excellent

[@RISHIKUMAR-gm9wm]

Teacher our student wali full feeling aati he sir

[@Innozant]

Thanks Rishi sahab .happy learning ❤️

[@rohitpatial1113]

Very helpful video sir. !!

[@Innozant]

Thanks dear

[@harjeetsingh2341]

Sir, custom formatting se bhi ho jaayega

[@vishwadeeptayde5179]

Rept function is new for me...thank you

[@Innozant]

Thanks Vishwadeep ji

[@REX-vo9yz]

Sir. Custom formatting m ja kr "000"# ye pass krne v zeros add kr skte h na??

[@Innozant]

Haaan kyu nahi

[@karankapoor200]

super video sir 👍🏻''

[@AnkitSingh-mh7ee]

Nice video sir.

[@dpak_sharma]

Very nice video sir

[@arpannandy961]

Excellent❤❤❤❤

[@Innozant]

Thanks Arpan

[@operationbroomstick]

Thank you my friend

[@navneetsinha6318]

Thanks buddy

[@Tahsiqra]

thank you sir

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@jogendrakumar3356]

Nice tricks!!

[@Innozant]

Thanks dear..keep learning

[@bhoopendraraghav9781]

Super se ooper....

[@Innozant]

Thanks Bhoopendra ji..for wonderful feedback

[@bhoopendraraghav9781]

@@Innozant welcome sir

[@swatisatpathy2315]

Thanks a ton

[@Innozant]

Thanks Saanvi.. Happy learning ❤️❤️

[@Farhansaikh00]

Sir, tell me how to join your class please

[@islamic31399]

Great

[@Innozant]

Thanks dear

[@sushmayadav-dc3qc]

Thnkyou sir

[@hemantgusain1260]

Lovely trick

[@Innozant]

Thanks Hemant..Keep watching and share

[@gauravbhatia7987]

Good sir

[@Innozant]

Thanks ❤️🙏

[@amitazad7]

Please details the information regarding '&' Means uses of '&' it will helpful

[@Innozant]

&- Ampersand operator. And it is use as substitute of concatenate function to join several text string into one

[@DEADYBOYS]

I have a idea Custom format se bhi ho jaega sir

[@Innozant]

Good Nirmal, Attempt and share with all

[@bharat_makwana]

how to use this trick with any formula??

[@ManojGupta-nl8fj]

Sir, Maine web page se table copy kar excel men pest ki jisme data 021, 002,035,040 ke rup men hai. Mai chahta hu ki ye 2 digit me ho.ise kaise karenge Maine is par trim, number me change karna, custom format ka use Kiya lekin nahi ho paya.ant me text to column fixed width se Kiya lekin sare column ke data ko sudharna lambi prakriya hai kripaya samadhan batane ka kasht karen.

[@PrateekGoyal013]

ctrl+1 se format change krke number krdo

[@jindusingh3552]

👌👌👌👌

[@lightningeagle5087]

Agar paste special krege toh error (green) show ho raha h

[@amarjeetsingh8537]

=right("00000000"&cell,5) Sir ye bhi kar sakte hai🙏

[@Innozant]

kaunse ques me

[@amarjeetsingh8537]

Same sir zero add karne ke liye

[@chetan1008]

👍👍👍

[@pankajkumar-uz9jy]

Sir VBA pe kab se start kroge aap

[@Innozant]

Kuch time baad..abhi adv excel ..then SQL VBA both

[@pankajkumar-uz9jy]

@@Innozant great sir.. M abhi as a MID coordinator working hu... But VBA ka pura concept clear nhi h...

[@Innozant]

Koi nhi give me sometime.. surely publish VBA and SQL video as well.

[@pankajkumar-uz9jy]

@@Innozant advance very bery very thanku so much sir..

[@hadiskhan7868]

hi sir aap telegram channel create kariye taaki hum log wahan pe bhi aap se jud sake or wahan pe bhi hum sabhi log aap se doubta hoga toh wahan pe bhi pooch sakte h

[@mayurchavda1005]

Sir mujhe aisa formula chahiye 0 ke liye jo har cell me ek hi 0 aaye...jaise invoice number ho...jaise ki challan number ho...uske aage jitne ki jarurat ho utne hi hum 0 laga sake...agar 1 zero ki jarurat hai to 1 hi zero likh sake..har bar formula changa karna na pade..aisa koi formula bataiye

[@PrateekGoyal013]

text function se kr lo =text(value,"00000000") jitne digit ka number chahte ho uske aage baaki zero lg jaenge

[@TheVaibhav1982]

Rept function wala best hai

[@Innozant]

Thanks

[@PrateekGoyal013]

sabse bkws hai vo

[@soniajohnson7957]

👍👍👍👍👍👍👍👍👍👍👍👍🏻👍🏻👍🏻

[@Innozant]

Thanks Sonia..Keep Learning ❤️

[@ssaap1212121121]

Sir isme hmne 5 ooooo kyu pass kiya

[@Innozant]

To convert ot as text

[@devsaxena7165]

Woww sir ji sir apka no.milega Sir ji 2 no.ki sit banata hu mai 00 typ krne me hr bar tex par jana padta h hamesa ke liye kese probilem solve kre

[@Innozant]

@innozantofficial telegram id

[@PrateekGoyal013]

custom formatting pe jaake set krlo

[@Excelpro75]

Sir, Very useful Vedeo.Sir, Can you help me for following problem. Eample: HY24312 23202 I need "HY" and space have to be removed with single formula. Is it possible. Please help.

[@Innozant]

Didn't get u..If you want to extract HY ftom HY24312 then what's prob in that ?share Ques. Sample

[@xlpointacademy5127]

Sir aapka Name kaya hair aap Noor Sir hai kaya

[@Innozant]

Nahi ji...aap kinko search kar rahe hain dear.❤️🙏

[@gamitashok1490]

4.5 hai use 0.045 kese kre

[@Innozant]

Custom formatting

[@PrateekGoyal013]

multiply krdo 0.001 se

[@shwethakm7060]

Lovely

[@Innozant]

Thanks Shwetha 😊

[@munendrarathore01]

Gazabe hai j

[@Innozant]

Thanks ❤️

[@kalaivanik6950]

Thank you sir

[@farhanilyas12]

Thanks Sir