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
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 हो सके | ; )
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
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
@@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.......! ❤️👍