Custom Number Formatting in excel | MS Excel for beginners lesson-7 | Number format in excel

  Рет қаралды 116,673

Computer Gyan Guruji

Computer Gyan Guruji

Күн бұрын

Пікірлер: 84
@ajaydelhi5
@ajaydelhi5 Жыл бұрын
It's the first time I got this concept, Thank you Sir
@MuhammadTahir-jy5sr
@MuhammadTahir-jy5sr 2 жыл бұрын
Thank u soooo much Sir, Love & Respect from Pakistan❤
@dkgdkg546
@dkgdkg546 2 жыл бұрын
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.
@kingsharafat1042
@kingsharafat1042 Жыл бұрын
Liked your teaching attitude
@A.Francisco-ip5bl
@A.Francisco-ip5bl Жыл бұрын
great great Sir. you are truly blessed
@designvelly4048
@designvelly4048 Жыл бұрын
Sir apki class bohut accha laga.. Thanks a Lot
@mukeshkumar-hd5yn
@mukeshkumar-hd5yn 2 жыл бұрын
wonderfull explain
@engg.sudarshanverma6599
@engg.sudarshanverma6599 3 жыл бұрын
Really wonderful teacher I have ever come across.The method of making others understand is really marvellous.
@ImranKhan-xp3nw
@ImranKhan-xp3nw Жыл бұрын
Thank you for this video
@manshisinghrajputrajput2380
@manshisinghrajputrajput2380 16 күн бұрын
Wow❤️
@ABCDEFGHI783
@ABCDEFGHI783 2 жыл бұрын
Very useful video Thanks Sir
@mohitkumar986
@mohitkumar986 2 жыл бұрын
best information sir ji,all youtuber
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
So nice
@hitenmakwana5093
@hitenmakwana5093 Жыл бұрын
Good explanation 🔥🔥
@manjit.sarania
@manjit.sarania 2 жыл бұрын
Very important information is
@avr9747
@avr9747 3 жыл бұрын
Excellent in depth analysis of the basics.rarely you would find so much insightful teaching. Many thanks&best wishes Ashish
@bibhuduttabagar3946
@bibhuduttabagar3946 Жыл бұрын
Good job sir
@vp_nofficial917
@vp_nofficial917 7 ай бұрын
you got 1 more subscriber
@mangalpandey7875
@mangalpandey7875 2 жыл бұрын
Very good sir
@raviadisare
@raviadisare 2 жыл бұрын
नमस्ते सर, अपने Custum Number Format के बारे में जो जानकारी दी बहूत ही अच्छी दि है | सर मुझे Custum Format में हेक्टर - आर - प्रती 01 - 40 - 9 का ऐसा फॉर्मुला बनाना है |
@mahendrachaudhary6107
@mahendrachaudhary6107 2 жыл бұрын
Very nice Sir!
@mudokulamgopinaik1397
@mudokulamgopinaik1397 4 жыл бұрын
Sir good explanation
@jalandhargouda9728
@jalandhargouda9728 Жыл бұрын
Marvellous
@panathulamasthanbabu4834
@panathulamasthanbabu4834 Жыл бұрын
Sir ji can you please explain this topic - advanced formats
@onlyconstruction1243
@onlyconstruction1243 3 жыл бұрын
Thanks
@ashutoshpandey6265
@ashutoshpandey6265 4 жыл бұрын
This is my first video on your channel, I liked your teaching style and specially you taught all related shortcuts which were more helpful.
@ComputerGyanGuruji
@ComputerGyanGuruji 4 жыл бұрын
Thanks and welcome
@sumitpatra1435
@sumitpatra1435 4 жыл бұрын
Thanks sir
@kansingh5968
@kansingh5968 3 жыл бұрын
Nice.
@shaileshrane8542
@shaileshrane8542 4 жыл бұрын
Very good
@kavitakashyap4428
@kavitakashyap4428 2 жыл бұрын
Yadi 0 vale coloum m all salect karke saare numbers pe apply karenge ye toh sab m ye custom vali formatting le lega ...?
@jalandhargouda9728
@jalandhargouda9728 Жыл бұрын
Will you please explain how to write +2 Science
@prakashdash9971
@prakashdash9971 2 жыл бұрын
Maine abhi Lokesh lalwani ki ek video dekhi custom formatting ke upar Content exactly yahi tha ,kaise ? Kya aap ne unhe copy kiya ??
@ffloveryug
@ffloveryug 3 ай бұрын
मनोज जी अलग अलग कॉलम में दी हुए संख्या से दो अंक एक जैसे होऔर दो अंकों का जोड़ 100 हो इसके लिए एक्सल में कोई फॉर्मूला है यदि है तो बताए।
@mohitkumar6597
@mohitkumar6597 10 ай бұрын
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
@syedmuhammadakbar3699
@syedmuhammadakbar3699 Жыл бұрын
Give link of Custom category for time format pl.
@lkychadda7341
@lkychadda7341 5 ай бұрын
Sir ji 1:1.5:3 ye kis format se aayega
@damangill3372
@damangill3372 2 жыл бұрын
Number likh kr adjuster use kr sakte hain na
@RayenDoudi
@RayenDoudi 4 жыл бұрын
first
@AaAbid-sp5rd
@AaAbid-sp5rd 2 жыл бұрын
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?
@sidrathulmuntaha
@sidrathulmuntaha Жыл бұрын
TEXT WITH NUMBER MEAIN EK SAATH KG, MTR OR PCS CUSTOME NAHI KAR SAKTHE OH JI?
@legendaura6705
@legendaura6705 3 жыл бұрын
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😊
@fazalrashidalam4652
@fazalrashidalam4652 2 жыл бұрын
Mera ek bhut important question hai Positive number blue color hoga or percentage value red hoga help plz
@fazalrashidalam4652
@fazalrashidalam4652 2 жыл бұрын
Red color
@ch.gourabpatro7588
@ch.gourabpatro7588 2 жыл бұрын
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.
@avinashpushpan
@avinashpushpan 2 жыл бұрын
you can do it by conditional formatting
@sapeduworld
@sapeduworld Жыл бұрын
(Green )(greater than sign 150)#;(Red)(less than sign 150)# Use straight bracket not this bracket as shown in comment
@govinggupta1930
@govinggupta1930 Жыл бұрын
Sir as freasher excel me koi job tho batao
@easytospeak4178
@easytospeak4178 3 жыл бұрын
Sir isme special ka kya use hota h jo custom k thik upper likha hota h special
@ArshadTKEXSMajYoututbecreator
@ArshadTKEXSMajYoututbecreator Жыл бұрын
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
@AnkitKumar-io3dv
@AnkitKumar-io3dv Жыл бұрын
Sir koi website bataiye online dat entry work ke liye jo fake nahi ho sir reply karoyega
@satishsarode5809
@satishsarode5809 3 жыл бұрын
Isme character separated ke liye konsa option hai means satish ki jagah s a t i s h aise ana jahiye
@ramijrejamondal9196
@ramijrejamondal9196 2 жыл бұрын
How I typeing CN3705 Letter and Number
@yateemkafalat1882
@yateemkafalat1882 2 жыл бұрын
How to use custom format if we want to load KG, ML, LTR, GM in same column?
@AshishKumar-pu9gs
@AshishKumar-pu9gs 3 жыл бұрын
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
@Prasaad.Yepuri
@Prasaad.Yepuri 2 жыл бұрын
How to add numbers desimal separated by comma - like 2,75
@SumaiyyaSummi-se3dw
@SumaiyyaSummi-se3dw 5 ай бұрын
Muje ek number ke baad point aana hai uske liye kya kare sir
@sanjeevkumar-gh2tp
@sanjeevkumar-gh2tp 4 жыл бұрын
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
@ComputerGyanGuruji
@ComputerGyanGuruji 4 жыл бұрын
hamne dateif or date ke bare me pura video banaya hai aap dekhiye or formula dateif nahi datedif ka hoga kzbin.info/www/bejne/a6K0d5-XjLGGd6s
@ketultrivedi5692
@ketultrivedi5692 3 жыл бұрын
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
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
you need clear all formating
@SubhamKumar-lu6fz
@SubhamKumar-lu6fz 4 жыл бұрын
Sir... Mere excel worksheet m 1 type krne pr 0.01 show krta h toh hum ushe kaise thik kr skte h
@mukeshmehra2086
@mukeshmehra2086 Жыл бұрын
I want to change KB to GB format how can I do this?
@mudokulamgopinaik1397
@mudokulamgopinaik1397 4 жыл бұрын
Sir VBA coading one video ples
@ComputerGyanGuruji
@ComputerGyanGuruji 4 жыл бұрын
bhi vba coding ki puri series le kar aa rahe hain
@meenakshinegi4196
@meenakshinegi4196 Жыл бұрын
Aap ne 10 kg custom format toh wo number format mein hua...mgr data pehle se 10kg aur tb calculation kre toh kaise hoga....
@devnathchouhan1114
@devnathchouhan1114 2 жыл бұрын
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
@gamitashok1490
@gamitashok1490 Жыл бұрын
4.5 hai to use 0.045 kese karna hai sir
@zoyasiddique8274
@zoyasiddique8274 Жыл бұрын
, ka use pura nhi btaya kese kese lga sakte h
@devnathchouhan1114
@devnathchouhan1114 2 жыл бұрын
Aap isme Jo sikha rhe ho sir usme ye bato ki 12.17 bata rha hai usko 1.21 karna hai to kese hogha
@ismailafridi7028
@ismailafridi7028 Ай бұрын
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
@bsbharti1389
@bsbharti1389 2 ай бұрын
10/- Excel agar aise jodane hai to kaise kare
@SubhashSharma-u7p
@SubhashSharma-u7p Жыл бұрын
separator code for Hundred and Lakhs
@rohitbhateja8022
@rohitbhateja8022 2 жыл бұрын
When I enter 1 it appears as 0.000001. Kindly help
@ihavealsoheart
@ihavealsoheart 2 жыл бұрын
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 😭
@ifatjan9185
@ifatjan9185 Жыл бұрын
aaf nay computer my kuen c degree ki
@neelamelectricalengineerin5278
@neelamelectricalengineerin5278 2 жыл бұрын
copy cat your copy the content of the LOKESH LALIWANI
@shubhagarwal6162
@shubhagarwal6162 2 жыл бұрын
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
@anuj_jain7
@anuj_jain7 Жыл бұрын
sir apka number mil skta hao
@MuhammadAbbas-edu
@MuhammadAbbas-edu 9 ай бұрын
Thanks
@bijaytanty8434
@bijaytanty8434 3 жыл бұрын
Thanks Sir
@Rncogdy-.
@Rncogdy-. 2 жыл бұрын
Thanks sir
@shiwanimaurya5307
@shiwanimaurya5307 6 ай бұрын
Thankyou sir
Why you SHOULD be USING Custom Number Formatting in Excel
9:51
Leila Gharani
Рет қаралды 309 М.
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 44 МЛН
How to Format Cells Custom in Excel: A Step-by-Step Guide
16:36
MANOJ KUMAR EXCEL
Рет қаралды 63 М.
11 Zabardast Excel Tricks 🤯🔥
22:31
Desi Goodly
Рет қаралды 44 М.