नमस्ते सर, अपने Custum Number Format के बारे में जो जानकारी दी बहूत ही अच्छी दि है | सर मुझे Custum Format में हेक्टर - आर - प्रती 01 - 40 - 9 का ऐसा फॉर्मुला बनाना है |
Hi Dear, Thanks for the video. I have a quarry. If I want to make .6=1, it increases like .1,.2,.3,.4,.5 when it's .6 it makes 1.0. like 1.1,1.2,.................1.5 and next Stape is 2 in one cell? how can I make it?
Sir please tell me if we write in Excel value 1170 but zer gaib ho jata tou 117 rah jata hai issko kaisekarein ya custom mein kiya type Karen tou thick hojaye
Sir mera two dates ke beach may month ka difference ka and ryt nehi aata datedif farmulas pta nehi kyu jaise 1-05-2015 se 30-05-2015 may difference two month ka par mera and 1 aata ese meko salary arear bnane may problem aa rahi sir solve this problem plz
Muje ek doubt hai... ki agar muje jaise number type karna hai but piche 2 decimals hone chaaiye like 5555.55 aisa kuch toh vo toh ho jaayega but agar muje usme jaise sirf 5555 hi add karna hai to kya conditional formating karna padega bcoz muje meters type karna padta hai toh jaise agar 5555 meters hai to vo automatically 5555.00 aisa aata hai.. n kabhi kabhi muje 5555.45 aisa kuch meters bhi aata hai toh muje aisa chaaiye ki like vo ek hi cell me 5555 meters type karu to decimals show nahi hone chaaiye lekin agar type karu to 5555.45 aisa bhi show hona chaaiye toh plzz sir help kar do.. bcoz maine try kiya toh vo ho toh raha hai but point bhi aa raha hai like 5555. aisa
Sir ap na positive or negative number dono ko format krna kaliya 0 hi use kiya negative number kaliya -0 kio nhi kia ya wala concept clear nhi hua someone answer me
Sir please help you mera work rs ka hota jese koi amount hai 1200000 Rs price hai to muje 1.20 cr chaiye Or usme 1.20 Cr me + 25 lac plus karte hai price 14500000 isee price aate hai ye price muje 1.45 Cr karana hai to kese karte hai
You had nothing yours you just copied it from other channel that's why you were not able to explain the space part that cleary which was tough one.. I really can't believe how people like you copy the stuff and earn money At least change the figures or format etc. Everything is ditto
It's the first time I got this concept, Thank you Sir
Sir apki class bohut accha laga.. Thanks a Lot
I live in Tokyo I have learnt from your videos alot. Thank you very much for excel videos. I like your simple style and knowledge.
Really wonderful teacher I have ever come across.The method of making others understand is really marvellous.
Thank u soooo much Sir, Love & Respect from Pakistan❤
great great Sir. you are truly blessed
Liked your teaching attitude
Excellent in depth analysis of the basics.rarely you would find so much insightful teaching.
Many thanks&best wishes
Ashish
wonderfull explain
Wow❤️
best information sir ji,all youtuber
So nice
Very useful video Thanks Sir
Good explanation 🔥🔥
Good job sir
Thank you for this video
Very important information is
Very good sir
you got 1 more subscriber
Very nice Sir!
नमस्ते सर,
अपने Custum Number Format के बारे में जो जानकारी दी बहूत ही अच्छी दि है | सर मुझे Custum Format में हेक्टर - आर - प्रती 01 - 40 - 9 का ऐसा फॉर्मुला बनाना है |
Marvellous
Sir good explanation
Sir ji can you please explain this topic - advanced formats
This is my first video on your channel, I liked your teaching style and specially you taught all related shortcuts which were more helpful.
Thanks and welcome
Nice.
Very good
Thanks
first
Thanks sir
Maine abhi Lokesh lalwani ki ek video dekhi custom formatting ke upar
Content exactly yahi tha ,kaise ?
Kya aap ne unhe copy kiya ??
Will you please explain how to write +2 Science
Sir Micro cannot run macro Inventory purchase the macro may Not be Available in this Workbook or All Macro may Be disabled Solve Problem issue
Give link of Custom category for time format pl.
Yadi 0 vale coloum m all salect karke saare numbers pe apply karenge ye toh sab m ye custom vali formatting le lega ...?
Sir ji 1:1.5:3 ye kis format se aayega
Number likh kr adjuster use kr sakte hain na
Sir, i have a doubt for making a custom for highlight red if value less then 150. if more then 150 then green. then how to do it.
you can do it by conditional formatting
(Green )(greater than sign 150)#;(Red)(less than sign 150)#
Use straight bracket not this bracket as shown in comment
How I typeing CN3705
Letter and Number
TEXT WITH NUMBER MEAIN EK SAATH KG, MTR OR PCS CUSTOME NAHI KAR SAKTHE OH JI?
Mera ek bhut important question hai
Positive number blue color hoga or percentage value red hoga help plz
Red color
Hi Dear, Thanks for the video. I have a quarry. If I want to make .6=1, it increases like .1,.2,.3,.4,.5 when it's .6 it makes 1.0. like 1.1,1.2,.................1.5 and next Stape is 2 in one cell? how can I make it?
मनोज जी
अलग अलग कॉलम में दी हुए संख्या से दो अंक एक जैसे होऔर दो अंकों का जोड़ 100 हो इसके लिए एक्सल में कोई फॉर्मूला है यदि है तो बताए।
Sir as freasher excel me koi job tho batao
How to use custom format if we want to load KG, ML, LTR, GM in same column?
Sur mera serial no jab bhi likh raha hun 1 2 ki jagha 0.01 0.02 aise format me a raha hai general me change krne pr bhi nhi ho raha plz help sir g😊
I want to change KB to GB format how can I do this?
Sir koi website bataiye online dat entry work ke liye jo fake nahi ho sir reply karoyega
Sir isme special ka kya use hota h jo custom k thik upper likha hota h special
Isme character separated ke liye konsa option hai means satish ki jagah s a t i s h aise ana jahiye
Sir please tell me if we write in Excel value 1170 but zer gaib ho jata tou 117 rah jata hai issko kaisekarein ya custom mein kiya type Karen tou thick hojaye
How to add numbers desimal separated by comma - like 2,75
Muje ek number ke baad point aana hai uske liye kya kare sir
separator code for Hundred and Lakhs
Sir VBA coading one video ples
bhi vba coding ki puri series le kar aa rahe hain
Sir... Mere excel worksheet m 1 type krne pr 0.01 show krta h toh hum ushe kaise thik kr skte h
, ka use pura nhi btaya kese kese lga sakte h
When I enter 1 it appears as 0.000001. Kindly help
Sir mera two dates ke beach may month ka difference ka and ryt nehi aata datedif farmulas pta nehi kyu jaise 1-05-2015 se 30-05-2015 may difference two month ka par mera and 1 aata ese meko salary arear bnane may problem aa rahi sir solve this problem plz
hamne dateif or date ke bare me pura video banaya hai aap dekhiye or formula dateif nahi datedif ka hoga
th-cam.com/video/5qQFlaWLSAI/w-d-xo.html
12/18 value dalne pr date show ho rhi h lekin mujhe value esi formate me dalni ho to kse krege sir
Slace (/ ) k pahle or bad me bina space k
4.5 hai to use 0.045 kese karna hai sir
Aap ne 10 kg custom format toh wo number format mein hua...mgr data pehle se 10kg aur tb calculation kre toh kaise hoga....
10/- Excel agar aise jodane hai to kaise kare
Muje ek doubt hai... ki agar muje jaise number type karna hai but piche 2 decimals hone chaaiye like 5555.55 aisa kuch toh vo toh ho jaayega but agar muje usme jaise sirf 5555 hi add karna hai to kya conditional formating karna padega bcoz muje meters type karna padta hai toh jaise agar 5555 meters hai to vo automatically 5555.00 aisa aata hai.. n kabhi kabhi muje 5555.45 aisa kuch meters bhi aata hai toh muje aisa chaaiye ki like vo ek hi cell me 5555 meters type karu to decimals show nahi hone chaaiye lekin agar type karu to 5555.45 aisa bhi show hona chaaiye toh plzz sir help kar do.. bcoz maine try kiya toh vo ho toh raha hai but point bhi aa raha hai like 5555. aisa
you need clear all formating
Aap isme Jo sikha rhe ho sir usme ye bato ki 12.17 bata rha hai usko 1.21 karna hai to kese hogha
Sir ap na positive or negative number dono ko format krna kaliya 0 hi use kiya negative number kaliya -0 kio nhi kia ya wala concept clear nhi hua someone answer me
Sir please help you mera work rs ka hota jese koi amount hai 1200000 Rs price hai to muje 1.20 cr chaiye
Or usme 1.20 Cr me + 25 lac plus karte hai price 14500000 isee price aate hai ye price muje 1.45 Cr karana hai to kese karte hai
Sir ji, main yaha ye dhundne aaya tha ki lakh aur crore me comma ane ke liye kya trick bata rahe ho. Par wo mujhe mila nahi 😭
aaf nay computer my kuen c degree ki
copy cat your copy the content of the LOKESH LALIWANI
You had nothing yours you just copied it from other channel that's why you were not able to explain the space part that cleary which was tough one..
I really can't believe how people like you copy the stuff and earn money
At least change the figures or format etc.
Everything is ditto
sir apka number mil skta hao
Thanks
Thanks Sir
Thanks sir
Thankyou sir