Sir ji , excel videos ki playlist prepare kijiye .. its great to see short excel video tips in hindi for faster grasp of concepts. I love to download the playlist ..
प्ले लिस्ट पहले से बनी हुई है ये रहीं - एक्सेल के सभी वीडीयो यहॉ देखें - goo.gl/aF43Hs एक्सेस के सभी वीडीयो यहॉ देखें - goo.gl/LRohxH वर्ड के सभी वीडीयो यहॉ देखें - goo.gl/1yKpk1 कंप्यूटर नेटवर्किंग के सभी वीडीयो यहॉ देखें - goo.gl/9qmhvL फोटोशॉप के सभी वीडीयो यहॉ देखें - goo.gl/AVsjLZ विंडोज 7 के सभी वीडीयो यहॉ देखें - goo.gl/z44h2d जीमेल के सभी वीडीयो यहॉ देखें - goo.gl/h3EZzv यूट्यूब के सभी वीडीयो यहॉ देखें - goo.gl/zqzoJW टेक्नोलॉजी के सभी वीडीयो यहॉ देखें - goo.gl/pfQKsk
Sir aapka video bahut achha lga.बहुत बहुत धन्यवाद ,विडियो बनाने के लिए। लेकिन मेरा एक प्रश्न है मोबाइल नंबर लिस्ट में मोबाइल नम्बर के पीछे +91- कैसे add karenge. Pls pls pls sir इस topic pe video बनाइए . बहुत लोगो की ये समस्या है तो प्लीज सर जरुर विडियो बनाइये इस टॉपिक पर
It's very simple to add any number of zeros before a number in a Excel cell. You just type a single quote then type the number starting from zero. The whole number in the cell will be converted to text.
Bhai kaise ham sheet banaye jo Jo har style ka rate alag hai Par jab style name dale to uska rate auto show ho jaye aur quantity ka total account v show ho jaye. Please make video
Video to pasand bahut aaya par ham agar us formule ko use karke print karenge to jis cell ko lekar formula lagaya he wo bhi to print hoga uska kya kRna chahiye .
Nice Sir, Mere Paas Kuch Queries H. Kripaya Bataiyega. A. Kya Ek Saath Bahut Saari Rows, Columns Ya Sheets Insert Karne Ki Koi Trick ya Option Hai? Kya Macro Se Ye Ho Sakta H? Qki Macro Ko To Har Baar Run Karna Padta H. B. Kya Word Doc. Ko Excel Worksheet Se Link Kiya Ja Sakta H and Vice-Versa? Mtlb Hum Koi Data Type ya Fill Karein Word Me Aur Wo Apneaap Kisi Excel Worksheet Me Bhi Real Time Me Type ya Fill Hota Chala Jaaye??? Bataiyega Ji Om Sai Ram
Very Nice Sirji, Lekin Yadi Sabhi No's Ke Pehle Kewal Ek Hi Zero Lagana Ho Tab Kya Karenge? Mtlb, Maan Le 123456789012345, 32456, 45, 7899965, 666 etc. No's Ke Aage Kewal Ek Zero Hi Add Karna Ho To??? Thanks
Sir ager hum account no. Likh rahe hai to O formula ek hi cell me Kam karega ya pure cell me Maine try kiya neeche Tak drag ker ke but o formula usi cell me Kam ker rha hai jisme lagaya tha
yeh bataye ki excel mai exact sum kaisai pta karai . hamesha sum points ko round kar deta hai jaisai sum aaya 111.34 but excel btata hai 112 is ko kaisai 111.34 display karai
Kya yeh jo 11 plus digit ka jo problem use thik nahi kar sakte hai kyun ki yeh toh print mein bhi aise hi aata hai or copy karke world mein lejane mein bhi aata hai is ka koi solution nahi hai taki yeh error hat jaye
सर मुझे EXEL 2007 के लिये २/१० १२५० + २/१० १२५० की Equal =2500 ke लिये Formula चाहिये इसमे २/१० १२५० ऐ पहले Cell मे और २/१० १२५० ये दुसरे Cell मे है इसमेसे १२५० कि गिनती करणी है|
sir Excel me man lijiye kuchh name likha hua hai and ham har name ke pahle kuchh letter add karna chahate hai wo kaise hoga ex- sonu monu ram etc... in sabke name ke pahle dr. add karna hai kaise hoga
Thanks for this information
Bahut hi kaam ka video sir!
Wonderful sir..... Meri bhi yehin problem thi.... Apne solve kr diyan
Thanks sir ji ...solve my problem.
Kya baat he boss ..vry nic osm
Wow श्रीमान जी
Sir bahut bahut dnya wad aapka smsa ka samadan Kar diya
or b chanlles h but apka trika kafi acha h
and sir cmmnt m qus dekha kro mene apko phle quen b kiya tha pichle video me.
Superb 👌👍
Ji sir ye maza a gaya
Great teacher
Sir,
ऐसे ही जारी रखे | ; )
super sir be continue
Very nice formula thanks sir ji
Jabardast knownledge h sir ji
Start with apostrophe when you type more than 11 digits or start with zero (put an apostrophe and enter the digits, it will show only digits)
Thanks sir be continue....
good topic
Superrrr trick sir g
bahut acha h sir ji
bahut achachha laga
Nice information
Very nice video sir
very nice sir
Sir ji , excel videos ki playlist prepare kijiye .. its great to see short excel video tips in hindi for faster grasp of concepts. I love to download the playlist ..
प्ले लिस्ट पहले से बनी हुई है ये रहीं -
एक्सेल के सभी वीडीयो यहॉ देखें - goo.gl/aF43Hs
एक्सेस के सभी वीडीयो यहॉ देखें - goo.gl/LRohxH
वर्ड के सभी वीडीयो यहॉ देखें - goo.gl/1yKpk1
कंप्यूटर नेटवर्किंग के सभी वीडीयो यहॉ देखें - goo.gl/9qmhvL
फोटोशॉप के सभी वीडीयो यहॉ देखें - goo.gl/AVsjLZ
विंडोज 7 के सभी वीडीयो यहॉ देखें - goo.gl/z44h2d
जीमेल के सभी वीडीयो यहॉ देखें - goo.gl/h3EZzv
यूट्यूब के सभी वीडीयो यहॉ देखें - goo.gl/zqzoJW
टेक्नोलॉजी के सभी वीडीयो यहॉ देखें - goo.gl/pfQKsk
Nice information sir Thank you
Super Sir
Excellent
Very use ful
thnk u bhaiyya...
Very very thnx , Sir
Too nice
very nice video
Thank you so much sir
Awesome
Good sir
Well come sir, & Thank you so much
Thanks sir ji
Thank You Sir
Thank u.
Thnks sir ji
Sir aapka video bahut achha lga.बहुत बहुत धन्यवाद ,विडियो बनाने के लिए। लेकिन मेरा एक प्रश्न है मोबाइल नंबर लिस्ट में मोबाइल नम्बर के पीछे +91- कैसे add karenge. Pls pls pls sir इस topic pe video बनाइए . बहुत लोगो की ये समस्या है तो प्लीज सर जरुर विडियो बनाइये इस टॉपिक पर
Good morning sir,
Dear sir plz tell me ki excel ka Kya end nahi hota hai or y bhi btana ki excel me book mark kese lagta hai
Great
Thanks
good sir
V good
Sir Advance excel video bhi upload kare
👋 good sir ji
✌️ ✌️ ❤️ ❤️ ℹ️
awesome
Sir excel me font change krne ka shortcut key k baare me btaye.......
Thik hai sir
Super b
Goog video
Nice
sir what if some bank account number is in different digits and start with 1 zero or some starts with 2 zeros in a list then how to use the formula
It's very simple to add any number of zeros before a number in a Excel cell. You just type a single quote then type the number starting from zero. The whole number in the cell will be converted to text.
Sir this is very useful formula But sir hum chahte hai ki ye formula ko pahle se same cell me before enter number kaise lga sakte hai
Jaise ki hum number enter kre aur auto text me convert kr de
Sir this technique I know already
Word excel me sabhi menu ka step by step pdf format me dijiye
Bhai kaise ham sheet banaye jo
Jo har style ka rate alag hai
Par jab style name dale to uska rate auto show ho jaye aur quantity ka total account v show ho jaye.
Please make video
nyc
Video to pasand bahut aaya par ham agar us formule ko use karke print karenge to jis cell ko lekar formula lagaya he wo bhi to print hoga uska kya kRna chahiye .
Sir aadhar number ko 4-4 ke set me excel me kaise feed kar sakte hai
- dash laga kar
Ya number add karke decimal decimal places 0 karke
Sir 0.200,0.300 write krte h to piche 0 gayb kyu ho jate h
Nice Sir,
Mere Paas Kuch Queries H. Kripaya Bataiyega.
A. Kya Ek Saath Bahut Saari Rows, Columns Ya Sheets Insert Karne Ki Koi Trick ya Option Hai? Kya Macro Se Ye Ho Sakta H? Qki Macro Ko To Har Baar Run Karna Padta H.
B. Kya Word Doc. Ko Excel Worksheet Se Link Kiya Ja Sakta H and Vice-Versa? Mtlb Hum Koi Data Type ya Fill Karein Word Me Aur Wo Apneaap Kisi Excel Worksheet Me Bhi Real Time Me Type ya Fill Hota Chala Jaaye???
Bataiyega Ji
Om Sai Ram
AMIT KUMAR SHARMA way is only macro codes
Sir kush nums jo 11 digit se jayda ho uske aage bina 0 lagye kase show karva sakte hai??
Right click.... Formate colum..... Number... 0 digit se bhi yah masala aasani se hal ho jata hae to itana lamba method kyo?
Sir ye value hame same cell me type Karni ho to kya karenge
Computer me kruti dev 10 typing me आधा फ कैसे लिखें इस समस्या का हल बताते।
Bansabali kaise banaye sir
Sir Excel Mein laga hua formula ko delete kar ke naya formula Kaise Lagaye
sir....
jaise ki hum excel cell me 1. type karte hai to enter karne par 1 aisa ho jata hai...... aisa kyo hota hai iske baare me kuch bataye....
COLOUM A,B,C,D, KO APNE MUTABIK RENAME KAISE KARENGE
Very Nice Sirji, Lekin Yadi Sabhi No's Ke Pehle Kewal Ek Hi Zero Lagana Ho Tab Kya Karenge?
Mtlb, Maan Le 123456789012345, 32456, 45, 7899965, 666 etc. No's Ke Aage Kewal Ek Zero Hi Add Karna Ho To???
Thanks
Separate kere sir text se numbers ko
Sir ager hum account no. Likh rahe hai to
O formula ek hi cell me Kam karega ya pure cell me
Maine try kiya neeche Tak drag ker ke but o formula usi cell me Kam ker rha hai jisme lagaya tha
Sir number se pahle 0 lagane ki koi shortcut key h to bataiye
Sir ji ms word ki kisi ek hi file me 2ya jyada pages me header alag alag type karna ho to kese kare. Kyoki sabhi pages par ek hi header rehta hai.
जल्द ही इस विषय पर वीडीयो आपको मिल जायेगा
@@mybigguidehindi
Kya Video Banayi H Sir?
yeh bataye ki excel mai exact sum kaisai pta karai .
hamesha sum points ko round kar deta hai
jaisai sum aaya 111.34 but excel btata hai 112 is ko kaisai 111.34 display karai
Sir es me ek problem hai ki jab hum text kar dete hai or jab inka total karte hai to jinko text kiya hai unka total nhi hota
Sir 15 digit k jada digit kese type krenge .. bank account 17 digit ka hai.
Kya yeh jo 11 plus digit ka jo problem use thik nahi kar sakte hai kyun ki yeh toh print mein bhi aise hi aata hai or copy karke world mein lejane mein bhi aata hai is ka koi solution nahi hai taki yeh error hat jaye
Use custom setting this is text you can't some it
सर नमस्कार
मी एक्सेल में मराठी हिंदी इग्रजी
56 30+5 23+5 = 119 बेरीज कैसे करे
sir decimal mein number lupt ho jata
iska solution bta dijiye
Sir, if numbers converted into text then can we sum them?
Krishna Vemula no you can't
hello sir muje automatically alphabetical order me entry likhna hai wo kesr likhenge
आप टाइप करते समय ऐसा नहीं कर सकते है लेकिन बाद में आप उसे शार्ट करा सकते हैं
hello sir January,march,dec,feb es tarh se h koi Aisa formula h Jo months ka Naam line by line ho jaye
@@daltonganjcreation
Aap Excel Me Jan, Feb Type Karke Drag Kijiye, Excel Automatically Aage Ke Months Fill Kar Lega. Ya
सर मुझे EXEL 2007 के लिये २/१० १२५० + २/१० १२५० की Equal =2500 ke लिये Formula चाहिये इसमे २/१० १२५० ऐ पहले Cell मे और २/१० १२५० ये दुसरे Cell मे है इसमेसे १२५० कि गिनती करणी है|
sir Excel me man lijiye kuchh name likha hua hai and ham har name ke pahle kuchh letter add karna chahate hai wo kaise hoga
ex- sonu monu ram etc... in sabke name ke pahle dr. add karna hai kaise hoga
Sir shirf tex format karne se 0 bhi aa jata he to ye formula ke chakkar me kyu pade.?
Sir mughe HLOOKUP ka uae karna batay data se sath
excel 18 digit number कैसे
सर स्टांप पर टाइप कैसे करे
2-3 likhne pr 2 feb likha aata hai means date format m change ho jata hai koi solution????
R/S AGAR SIMPLE TRIKE SE GENERAL KO TEXT KAR DETE OR ZERO LAGA DETE HE TO BAD ME TEXT KRNE SE US CELL KA SUM NAHI HOTA
But "0" lagane k bad us value Ka sum nahi Kar sakte aisa q????
Sir aisa kyu hota h excel 11 digit se jyada kyu nahi leta..
Sir ziro nhi sirf digit likhana ho to Kya Kare es error ka 17 likhana h mere ko...plz help me#####
Hahaha I think iske jagah pe hum number format ka use karein toh jyada sahi hota