Tips - Excel में 15 Digit से लम्बी संख्या कैसे लिखे - How To Write Larger Number In Excel
Вставка
- Опубліковано 11 жов 2024
- Microsoft Excel convert digits (more than 16) to an equation while entering account number, aadhar number or any other large number information, here is solution for those problem.
How to enter.write large/big numbers in Excel
How to enter credit card numbers in Excel
How to enter numbers larger than 15 digits into Microsoft Excel
Vlookup In Excel - VLOOKUP VIDEO SERIES:
1. vlookup in excel with example in Hindi
• Vlookup in Excel With ...
2. How to use vlookup for multiple values || Trick to use vlookup for large data
• सारा Data एक बार में V...
3. Vlookup in multiple sheets in excel || In Hindi
• Vlookup in multiple sh...
4. How To Use Double VLookup in Excel-Nested vlookup
• How To Use Double VLoo...
5. Dynamically Updated Vlookup Formula in Excel
• How To Make a Dynamica...
6. How To Use Vlookup With Multiple Excel Workbooks
• How To Use Vlookup in ...
7. VLOOKUP With MATCH Function In Excel
• How To Use VLOOKUP Wit...
8. HLOOKUP in excel with example in Hindi
• HLOOKUP in excel with ...
9. Hlookup With Match Function in Excel in Hindi
• Advanced MS Excel - Hl...
Hope you will like the video. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
________________________________________________
ADVANCED MS EXCEL ► goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS ► goo.gl/bbHYu2
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER Tips & Tricks ► goo.gl/paZmpn
Subscribe to my channel ► / deepakeduworld
Like my Facebook page ► / deepakeduworld
Thanks for Watching
Happy Learning
ER DEEPAK NEHRA [ M.Tech. ]
**********************************************
Very much thanks yarrr bahut pareshan hua kafi logo ko call krke pucha phir yadd aaya youTube and pehli bar me samaj aa gya thanks bro.... Good work keep it up
Apko dil se salam karta hu dost mereko pareshan kar dia ich problem ne
Apostrophe lagake iss trick ko solve kar sakte hai. That's very simple I don't know thank you so much Deepak.
Are bhia thank you so much mera pura din nikal gaya is chakkar me 😢❤❤❤
Account me bahut help full hai apka videos sir
Sir ek video iss pe bhi banao ki jab hum koi data download krte hai to excel me already more than 18 digit rehte h to usse hum kaise sahi karein sare cells me ek sath. Like hum company ka excel download krte hai to usme serial number ka column hota serial number 18 digit ke hote hai but jab uss serial pe click krte hai to vo 000 dikhata h last me to ye bataiye ki already download data me kaise sahi karein 18 digit ke numbers vo bhi ek sath sari cells me
thank u so much bhai... bht time lga mujhe sahi krne main..
Thanks for providing such type of videos
You are helping me to improve my knowledge in computer
Thank you so much 🙏
Thanks bhai
Thank you so much sir. Aap ese hi helpful video banate rahiye.
Trick kaam karti hai thanks for helping sir ❤
bahot hi badhiya bhai sahab👍
Thanks very very much,me office me is problem Ko face kiya or apne mujhe very good solution btaya..again thanks..God bless you
Good trick Deepak bhai but AAP ms word ki videos published kab kar rahe ho
Sir ek bill me bahut sare stock jaten hai uska ham add krten h lekin excel sheet me sabhi add ho jaten ham chahten hsi ki group total ek bill ka sahi rhe aur indiddual alah to kya kre
Sir Me Bangladesh se. Sir apka ich trick pe koi formula use kiya toh kisi tara se problem hoga ki nehi? plz sir bataye.
So helpful video bhaiya
Very thanks
Very nice. U r great. Very very useful video for me.
Nice trick...Thanks a lot
Thanks alot
Thanks you sir 🙏 🙌 ☺ 😊 👍 ❤ 🙏 🙌 ☺ 😊 👍
Thanks sir muze eska fayda ho gaya.....
Thankyou solving this problem
Deepak Sir,
बिल्कुल problem रोज़मर्रा की है | अब एक मेरी problem solve कीजिए, जब हम vlookup या hlookup या index+match से data match करते है तब cell का text data number data से match नहीं होता, उसके लिए ignore error का उपयोग करना पड़ता है | अगर data हज़ारों में हो तब कैसे text data को number data में convert किया जाए ताकि data matching हो सके | ; )
Okay g
भाई, क्या तुम्हारी समस्या का समाधान हो गया ? मुझे भी यही प्रॉब्लम है ।
Thank you very much sir excel me itna important lesson sikhane ke liye
This works. However if I already have a 16 digits numbers which is been displayed as exponential how do I convert it back to its original state ? @deepak
❤very good sir
Thanks
Very very very very good sir g
Thnks
Thanku मेरी वज़ह से आज किसी का नुकसान हो जाता लेकिन आप की trick नुकसान होने से बचा लिया
👍
Thanku very much sir
Thanks a lot deepak ji helpfull
Ek sath text format me bahut se numbers ko kase change karenge
Thank u bro ,,,, lots of love ❤
Very useful information Sirji
Excellent tricks
Thanks a lot for uploading. I was facing daily this issue.
Sir please excel ki saari video ki link btaaye
Thank you so much brother
You are great
Please sir ms word per video banaiye
Thank you very much
Thanks ❤
Nice
Thankyou Sir
Good vidio.
MR. TARUN NICE VIDEO SIR JI
tarun tarun
Please tell us how to sum or add big numbers entered as texts
Very good LAJABAB
thanks brooo nice
Copy paste pr nhi ho rha h khud se likhna pad RHA tha 16 digits no. Agar copy paste krna h to kese krenge
Thank you so much sir ! It really helped me.
It's very helpful
Thank u sir bahut bahut tnx
Mere text ke option me v genral form me hi plus jesa likha hua phle se fill h jo change nhi ho raha h apke video me apke text ke option me sample blank tha pr mera nhi h how can i change that plzzzzz replay
Aap wala way out use kernay kay baad excel same column ki basis per sort nahi kerta ya karay to again number/value to trim ker deta hai.
Thanks 🙏, very helpful for me.
Sir, how to count large numbers digits in cells ?
for eg. 1000000 has 7 digits & 10000000 has 8 digits.
Very helpful
Online excel sheet download karne par usme 15+ digit hone par usko kaise set kare
Nice video sir
Thanks a lot for uploading. I was facing this issue.
Computer me old Text document file open nahi ho rahi he kya kare please help me
Good Information
Helpful video 😘😘
But copy Microsoft Word table k long number kese excel main paste kare.
thanks broo
Thnxx दोस्त
Fill handle not working in both scenarios either we use quotation mark before number or formate as text the fill handle can only drag down the same value instaed of fill serieas
Tnx sir 🙏
Thank you
Thank you sir explained very well 😊
Thanks bhayya
Agar big numbers ki list pehle se ho to sabhi numbers ke aage single quote lagane ki koi short trick bataiye plz
How to use help in ms excel 2019. Please guide me.
2nd best tha thanks bhai
Hi . Kya aap bata sakte hai k excel cell main image kese lagai jati hai jese football tabal main name k sath flag bhi . Aur jab name chang ho tu apne aap flag bhi chang ho jaye .
Okay.. I will publish video
Deepak EduWorld ua-cam.com/video/seVavgMMja8/v-deo.html is tarha ka
आप के होते हुए हमें कोई मुश्किल नही आ सकती।thank
😊
Great sir
Excel Me hindi meening ke liye kon sa shortcut key istemal karte hai
sir ap excel m customized software bnana bhe skhy q k sir m apne university k project excel m bnana chahta hun help me sir
Please watch ua-cam.com/video/UXyMncEkQFU/v-deo.html
Thankyou soo much
Great Bro....Thanks
Excel m numner kaise add kren??
Deepak Sir, if got a file with more then 19 digits are there in cells,then how to extract our data without losing data
Just select whole column.. And change its number format into text
Thanku so much
Thanks lot of for this..
Help full
GOOD HELPING SIR
Can u personally train me advance,VBA and all ms office
I want to use more than 15 digitise in number format, not in Text format
because other formulas that is for only number is not working in test format
Have you any idea sir ? 🙏
Love you sir
Sir jab copy or paste karte hai tab???
Plrase creat a video on autoupdate stock from invoice using vba
Sir mere system me nahi ho raha why
But we can't add the numbers more than 15 digts in Excel so howww??
15 digit tk ka place value kitna bnega ....kbhi socha h....aap toh aa gye bs add krne😊
@@sobhitkumar1682 hnjiiii bilkul socha h vo computer h aap k dimaag nhi😁 ki nhi ho paaegaa sb possible h agr krna ho to aur y hi bhi gya mera bhaisaab.......! ❤️👍
copy paste me kaise kar sakte hain