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. ]
    **********************************************

КОМЕНТАРІ • 230

  • @harshsachan7065
    @harshsachan7065 4 роки тому +4

    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

  • @derajdtech4691
    @derajdtech4691 3 роки тому +3

    Apko dil se salam karta hu dost mereko pareshan kar dia ich problem ne

  • @surajbhardwaj428
    @surajbhardwaj428 6 років тому +1

    Apostrophe lagake iss trick ko solve kar sakte hai. That's very simple I don't know thank you so much Deepak.

  • @aartimetkari3523
    @aartimetkari3523 7 місяців тому +1

    Are bhia thank you so much mera pura din nikal gaya is chakkar me 😢❤❤❤

  • @pratapyadav9007
    @pratapyadav9007 2 роки тому

    Account me bahut help full hai apka videos sir

  • @muskanaslamkhan1215
    @muskanaslamkhan1215 Рік тому +1

    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

  • @amancafe122
    @amancafe122 3 роки тому

    thank u so much bhai... bht time lga mujhe sahi krne main..

  • @vkyadav9332
    @vkyadav9332 6 років тому +2

    Thanks for providing such type of videos
    You are helping me to improve my knowledge in computer

  • @jageshwarmaravi_2022
    @jageshwarmaravi_2022 9 місяців тому +1

    Thank you so much 🙏

  • @SHRAVANKUMAR-vo3ht
    @SHRAVANKUMAR-vo3ht 4 роки тому +2

    Thanks bhai

  • @madhusudanrana1943
    @madhusudanrana1943 3 роки тому

    Thank you so much sir. Aap ese hi helpful video banate rahiye.

  • @firemaster3.061
    @firemaster3.061 4 місяці тому

    Trick kaam karti hai thanks for helping sir ❤

  • @gniraj8501
    @gniraj8501 2 роки тому

    bahot hi badhiya bhai sahab👍

  • @anishnaryal7890
    @anishnaryal7890 4 роки тому

    Thanks very very much,me office me is problem Ko face kiya or apne mujhe very good solution btaya..again thanks..God bless you

  • @lokendrachand7859
    @lokendrachand7859 6 років тому +4

    Good trick Deepak bhai but AAP ms word ki videos published kab kar rahe ho

  • @sonukhan-yr1su
    @sonukhan-yr1su 2 роки тому +1

    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

  • @MonirulIslam-fw5zf
    @MonirulIslam-fw5zf 6 років тому +2

    Sir Me Bangladesh se. Sir apka ich trick pe koi formula use kiya toh kisi tara se problem hoga ki nehi? plz sir bataye.

  • @vijaylaxmisharma6318
    @vijaylaxmisharma6318 6 років тому +1

    So helpful video bhaiya

  • @ranjeetmaurya8109
    @ranjeetmaurya8109 4 роки тому +1

    Very thanks

  • @sanjayveterinarian8751
    @sanjayveterinarian8751 5 років тому +1

    Very nice. U r great. Very very useful video for me.

  • @santoshdhage2750
    @santoshdhage2750 4 роки тому +1

    Nice trick...Thanks a lot

  • @poojamittal9660
    @poojamittal9660 4 роки тому +1

    Thanks alot

  • @tarunabenbaria9624
    @tarunabenbaria9624 2 роки тому +2

    Thanks you sir 🙏 🙌 ☺ 😊 👍 ❤ 🙏 🙌 ☺ 😊 👍

  • @jagdishmore8856
    @jagdishmore8856 Рік тому

    Thanks sir muze eska fayda ho gaya.....

  • @cg_status_4_u47
    @cg_status_4_u47 2 роки тому

    Thankyou solving this problem

  • @puneetvij8433
    @puneetvij8433 6 років тому +2

    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 हो सके | ; )

    • @DeepakEduWorld
      @DeepakEduWorld  6 років тому

      Okay g

    • @parminderghai
      @parminderghai 4 роки тому

      भाई, क्या तुम्हारी समस्या का समाधान हो गया ? मुझे भी यही प्रॉब्लम है ।

  • @ajaymahawer1952
    @ajaymahawer1952 3 роки тому

    Thank you very much sir excel me itna important lesson sikhane ke liye

  • @rajesh6262
    @rajesh6262 Рік тому +1

    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

  • @harshit6778
    @harshit6778 Рік тому +1

    ❤very good sir

  • @mastimix7005
    @mastimix7005 2 роки тому +1

    Thanks

  • @deepchanddeepchand6201
    @deepchanddeepchand6201 5 років тому +1

    Very very very very good sir g

  • @priyadarsiniroul5134
    @priyadarsiniroul5134 2 роки тому +2

    Thnks

  • @AtulKumar-cf8uf
    @AtulKumar-cf8uf 4 роки тому +1

    Thanku मेरी वज़ह से आज किसी का नुकसान हो जाता लेकिन आप की trick नुकसान होने से बचा लिया

  • @MunishKumar-my9pc
    @MunishKumar-my9pc 4 місяці тому +1

    Thanku very much sir

  • @gauravchocolate
    @gauravchocolate 3 роки тому

    Thanks a lot deepak ji helpfull

  • @jeetj0628
    @jeetj0628 2 роки тому +1

    Ek sath text format me bahut se numbers ko kase change karenge

  • @ishfaqahmad9708
    @ishfaqahmad9708 2 роки тому

    Thank u bro ,,,, lots of love ❤

  • @aniketshivgan600
    @aniketshivgan600 6 років тому +1

    Very useful information Sirji

  • @suryapatel2396
    @suryapatel2396 5 років тому +1

    Excellent tricks

  • @MdIlyasShaikh
    @MdIlyasShaikh 6 років тому +2

    Thanks a lot for uploading. I was facing daily this issue.

  • @aashusharma5797
    @aashusharma5797 6 років тому +2

    Sir please excel ki saari video ki link btaaye

  • @chetanpatel5074
    @chetanpatel5074 2 роки тому +1

    Thank you so much brother

  • @shambusir4949
    @shambusir4949 3 роки тому +1

    You are great

  • @dharmendrakumarsingh3791
    @dharmendrakumarsingh3791 6 років тому +4

    Please sir ms word per video banaiye

  • @kulwinderrandhawa5958
    @kulwinderrandhawa5958 4 роки тому +1

    Thank you very much

  • @nageshsahu4756
    @nageshsahu4756 4 місяці тому

    Thanks ❤

  • @danishhussainansari4886
    @danishhussainansari4886 2 роки тому +1

    Nice

  • @honeyfoundation6654
    @honeyfoundation6654 3 роки тому +1

    Thankyou Sir

  • @yogawithprakash1269
    @yogawithprakash1269 6 років тому +2

    Good vidio.

  • @taruntarun4319
    @taruntarun4319 6 років тому +2

    MR. TARUN NICE VIDEO SIR JI

  • @rajeevgosavi4514
    @rajeevgosavi4514 3 роки тому +1

    Please tell us how to sum or add big numbers entered as texts

  • @sanjayjangirveersingh6527
    @sanjayjangirveersingh6527 3 роки тому +1

    Very good LAJABAB

  • @azeemrahi8996
    @azeemrahi8996 6 років тому +1

    thanks brooo nice

  • @mohinigoell7117
    @mohinigoell7117 5 років тому +1

    Copy paste pr nhi ho rha h khud se likhna pad RHA tha 16 digits no. Agar copy paste krna h to kese krenge

  • @abhijitaher9170
    @abhijitaher9170 4 роки тому +1

    Thank you so much sir ! It really helped me.

  • @emanuelsoren8159
    @emanuelsoren8159 3 роки тому

    It's very helpful

  • @mdrizvan3929
    @mdrizvan3929 3 роки тому

    Thank u sir bahut bahut tnx

  • @unspz9613
    @unspz9613 4 роки тому +1

    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

  • @sheerazi997
    @sheerazi997 4 місяці тому

    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.

  • @umeshkumar8727
    @umeshkumar8727 2 роки тому

    Thanks 🙏, very helpful for me.

  • @harsinchh4342
    @harsinchh4342 Рік тому +1

    Sir, how to count large numbers digits in cells ?
    for eg. 1000000 has 7 digits & 10000000 has 8 digits.

  • @nitishcomputer1739
    @nitishcomputer1739 3 роки тому

    Very helpful

  • @DineshSaini-fg3do
    @DineshSaini-fg3do 2 роки тому +1

    Online excel sheet download karne par usme 15+ digit hone par usko kaise set kare

  • @apeduworld7004
    @apeduworld7004 5 років тому +1

    Nice video sir

  • @ANILYADAV-gp6uv
    @ANILYADAV-gp6uv 3 роки тому

    Thanks a lot for uploading. I was facing this issue.

  • @sldcckota59
    @sldcckota59 2 місяці тому +1

    Computer me old Text document file open nahi ho rahi he kya kare please help me

  • @Abhishek-jl6dy
    @Abhishek-jl6dy 3 роки тому

    Good Information

  • @Smart360
    @Smart360 4 роки тому +1

    Helpful video 😘😘

  • @pramodmishra4367
    @pramodmishra4367 4 роки тому +1

    But copy Microsoft Word table k long number kese excel main paste kare.

  • @ftr.k.official4124
    @ftr.k.official4124 2 роки тому +1

    thanks broo

  • @gopalthakurtabahi6537
    @gopalthakurtabahi6537 Рік тому

    Thnxx दोस्त

  • @Arsal1616
    @Arsal1616 2 роки тому

    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

  • @raushankumar5864
    @raushankumar5864 2 роки тому +1

    Tnx sir 🙏

  • @arifanazia4491
    @arifanazia4491 6 років тому +1

    Thank you

  • @JyotiYadav-zs9we
    @JyotiYadav-zs9we 2 роки тому

    Thank you sir explained very well 😊

  • @mdkamranakmal5277
    @mdkamranakmal5277 2 роки тому

    Thanks bhayya

  • @akmishravns
    @akmishravns Рік тому

    Agar big numbers ki list pehle se ho to sabhi numbers ke aage single quote lagane ki koi short trick bataiye plz

  • @jpsharma9090
    @jpsharma9090 3 роки тому +1

    How to use help in ms excel 2019. Please guide me.

  • @prashantpatil7660
    @prashantpatil7660 4 роки тому

    2nd best tha thanks bhai

  • @sultanbakhsh582
    @sultanbakhsh582 6 років тому +1

    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 .

    • @DeepakEduWorld
      @DeepakEduWorld  6 років тому

      Okay.. I will publish video

    • @sultanbakhsh582
      @sultanbakhsh582 6 років тому

      Deepak EduWorld ua-cam.com/video/seVavgMMja8/v-deo.html is tarha ka

  • @amjadmkhan3383
    @amjadmkhan3383 6 років тому

    आप के होते हुए हमें कोई मुश्किल नही आ सकती।thank

  • @RIDINGADVENTURESRE
    @RIDINGADVENTURESRE 3 роки тому

    Great sir

  • @subhashsharma42
    @subhashsharma42 6 років тому

    Excel Me hindi meening ke liye kon sa shortcut key istemal karte hai

  • @sherazrathoor8552
    @sherazrathoor8552 6 років тому +1

    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

    • @DeepakEduWorld
      @DeepakEduWorld  6 років тому

      Please watch ua-cam.com/video/UXyMncEkQFU/v-deo.html

  • @मृणालराय
    @मृणालराय 4 роки тому

    Thankyou soo much

  • @kamalmaurya7098
    @kamalmaurya7098 4 роки тому

    Great Bro....Thanks

  • @sabakainat.5410
    @sabakainat.5410 3 роки тому +1

    Excel m numner kaise add kren??

  • @kirandeepchoudhry9232
    @kirandeepchoudhry9232 6 років тому +1

    Deepak Sir, if got a file with more then 19 digits are there in cells,then how to extract our data without losing data

    • @DeepakEduWorld
      @DeepakEduWorld  6 років тому +1

      Just select whole column.. And change its number format into text

  • @rvkenjoy7800
    @rvkenjoy7800 3 роки тому

    Thanku so much

  • @bhavindhaduk8543
    @bhavindhaduk8543 3 роки тому

    Thanks lot of for this..

  • @Utubemusic4you
    @Utubemusic4you 3 роки тому

    Help full

  • @satishvajja3310
    @satishvajja3310 4 роки тому

    GOOD HELPING SIR

  • @ashokkankariya5886
    @ashokkankariya5886 6 років тому +1

    Can u personally train me advance,VBA and all ms office

  • @aarishj5270
    @aarishj5270 2 роки тому

    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 ? 🙏

  • @anishsingh5111
    @anishsingh5111 3 роки тому

    Love you sir

  • @ashukumar881
    @ashukumar881 6 років тому +1

    Sir jab copy or paste karte hai tab???

  • @ritubratabasu6190
    @ritubratabasu6190 6 років тому

    Plrase creat a video on autoupdate stock from invoice using vba

  • @vishakhajain6931
    @vishakhajain6931 4 роки тому +1

    Sir mere system me nahi ho raha why

  • @kunalrathore261
    @kunalrathore261 5 років тому +4

    But we can't add the numbers more than 15 digts in Excel so howww??

    • @sobhitkumar1682
      @sobhitkumar1682 3 роки тому +1

      15 digit tk ka place value kitna bnega ....kbhi socha h....aap toh aa gye bs add krne😊

    • @kunalrathore261
      @kunalrathore261 3 роки тому +2

      @@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.......! ❤️👍

  • @rameshpatil2550
    @rameshpatil2550 3 роки тому +1

    copy paste me kaise kar sakte hain