I want it show like this 10,000 not 10,000.00 How to remove *.00* ? When I click on it the Digit it doesn't show *.00* to Delte it with Back space ? Next is a Auto Sum Total, how to so that cos its just a Formula when i click on that box ?
नमस्ते सर, अपने Custum Number Format के बारे में जो जानकारी दी बहूत ही अच्छी दि है | सर मुझे Custum Format में हेक्टर - आर - प्रती ( 01 - 40 - 9 ) का ऐसा फॉर्मुला बनाना है |
Hi Lokesh, that was a very helpful video. I am preparing Financials for my company and need to convert absolute numbers into Lakhs - without decimals and with a comma separator. Can you please help me figure out the format for it?
Dear Sir, I am facing one problem related to number formatting. I have data in my Excel sheet with currency of different countries Dollar, pound euro rupee and so on. I want to put command and decimal points as per the country specific formats. I have tried using regional settings. But it has not worked as per my requirement Hope you understand my requirement Please guide Manoj P Chakerwarti
sir app zoom kr k kaam kr rahy ho tou nazar nai aa rrahy hai ziada chezeen, aor ziada cheezen aoky sar k pechy rahty han ,tou kindly camra wala option uopar rakho gay tou insha allah agy vedios ma bahtareen kaam hoga,but thank you so much for detailed explanation
Sir number to color ho jata hai but number ke saath saath cell ko kaise color kare through custom (jaisa ki aapne bataya red karna hai to bracket me red likhenge)agar fill se color apply karte hai to number positive ho ya negative sab pe same hi color apply ho jata hai
Thank you so much....can I apply formula in custom formatting? Basically I want value to be shown in crores...i.e. if I enter 2,00,00,000 then excel should display 2 CR... thanking you in advance..
Sir, any form created by us we use in our worksheet and then if we send that worksheet to any body by mail or pen drive etc. I mean if we use that excel worksheet to other PC then it sheet will use that same formates ??? If yes then good but if No , then what to do... ??
Hi Ali, Glad you liked the video :) Also you can join my free Excel course here learn-with-lokesh-lalwani.thinkific.com/courses/Freemium-Excel-Course Happy Learning :)
Sir, I want to switch the percent or number to decimal automatically in a particular cell. From the Advance option, it applies in all cells. But I want it in only one cell. Eg. if I enter 50, it has to show 0.50 in particular cell not globally.
Hi Lokesh, Can you help me in making a custom format for Indian currency representation, for ex, 2280900 should show up as 22,80,900. by the way thanks for putting this up.
hi lokesh, your video is great. Is it possible to share how to share the numbering from Indian to International for example 10,00,000 to 1,000,000 format (example 10 lakh is 1m in international numbering system)
Dear friend, aap ka channel really bohat sikhane wala he, but aapki ki video ki waja se seen nahi ho saki detail, jis pe aap ki video thi. Please avoid the issue for your further videos
Hi, There are two level of Microosft certifications on Excel. 1. MOS (Microsoft Office Specialist) 2. Expert Level. You can simply visit certiport.pearsonvue.com/Home.aspx and search for the desired certification. As certiport takes care of all MS certifications. My recommendation: I have an in-depth course on Excel, which covers all the functions and features required to clear the above two mentioned exams. This course targets both of these certifications. Here is the link for the same: learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass Rest if you find any issue, ill be happy to guide you in the process of getting certifications as well. As i have done both :) All the best :) Lokesh Lalwani
Thanks for excellent presentation! I want to make excel worksheets for making engineering calculation. how to make a cell format combine for meter, feet, yard, numbers likewise. I mean when I enter a quantity in a cell it should come as per the description in left column. (ie, Meter (meters) (yard, Yards) (No, Nos)
Thanks. I have forwarded your query to Mr. Lokesh. Meanwhile if you are going to work on excel for a long time in future then you can enroll for our Masterclass from the link. It will save you hours of time and will help you progress in your career. learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass Sameer Team Learn with Lokesh Lalwani
I have to place two zeros after inserting number in general for exact value suppose I have to type 17500 but instead of this I have to type 1750000 two extra zeros for 17500. Please advice
How can we colour specific text in a cell, Example :- 1. Sum Of Amount 2. Sum of Data 3. Sum of Visit I want to colour only text "Sum" wherever it is written and rest of the text (of Amount, of data, of visit) should remain in Black.
Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥
Muje lack ke baad coma laga na hai kese lagaoo
I want it show like this 10,000 not 10,000.00
How to remove *.00* ?
When I click on it the Digit it doesn't show *.00* to Delte it with Back space ?
Next is a Auto Sum Total, how to so that cos its just a Formula when i click on that box ?
More explanation is needed in this custom formatting. particularly those pre-designed and shown by excel in its custom formats field.
you really deserve like, comment and subscription. subscribed
Sir bahut achha samjhaya
Thank u so much Brother 👍aapne bahut acche se explain kiya😊👍
Glad you liked it :)
नमस्ते सर,
अपने Custum Number Format के बारे में जो जानकारी दी बहूत ही अच्छी दि है | सर मुझे Custum Format में हेक्टर - आर - प्रती ( 01 - 40 - 9 ) का ऐसा फॉर्मुला बनाना है |
Sir,
Video is realy good. Thanku so much
sir aapki aavas bahot aachchhi aur clear hai video record karte samay aap konsa mic use karte ho please bataiye ga.
Very nice Lecture aapka samjhaane ka tarika bhut hi acchha hai.
Thanks SK.
Thank you very much sir to put this much effort selflessly
Thank you so much for your comment.
Please guide complete date formatting in video that how to apply formatting on random dates in column
Excellent
badia topic tha sir... ek bari me samjh aa gaya
Thank you so much for your comment. Glad you liked it!
Salam sir, plz told about data transfer from petty cash to other expsense sheet , office exp, bills, photocopies, etc
bro, it is the best video in custom formatting in excel. thank you from Bangladesh. BTW where are you from?
You are welcome
Life saving tips
Thanks for your knowledge explore 😊👍
Please make a video on time difference calculation in hours and how to generate serial no. automatically in next row
Sir make a video in which all conditions should be apply . Like freeze , filter,count , vlookup,table many more
Sir Ek Custom format complete banake samjhayie
Thank you for such valuable videos, sir can we custom format cell containing text with different colors.......please explain, thanks
Many many thanks sir jee u are great
Dost, you explained very well, but you could have put your video run on the left side
Thanks sir 🙏
I understand a lot of things from this lecture so thanks sir 🙏
Thanks you Khani :)
superb
Nice, Unknown basic fundamentals.
It's very nice
Great video sir thank you so much!
Glad it was helpful!
Ispar firse ek video banaiye sir
thank you, sir (very useful information)
Glad it was helpful!
Sir, Please tell me the format of cell under heading Expansion of Chest and the data are 85-92 cm, 93-97 cm, 101-106 cm , etc. in a column
Amazing video
Thanks for the visit
Nice sir.
Sir Conditional format ki ek pura video banaaiye sir
Hi Lokesh, that was a very helpful video. I am preparing Financials for my company and need to convert absolute numbers into Lakhs - without decimals and with a comma separator. Can you please help me figure out the format for it?
Hi…..have you found the way to do it? I am struggling with commas in thousands round off…It round offs the figure into thousand but no commas.
Sir place of comma kaise change krenge....means after every 3 digits? I.e. 2,343,547 because excel me 23,43,547 aata h
#","###","###
Mera b same problem
Dear Sir,
I am facing one problem related to number formatting.
I have data in my Excel sheet with currency of different countries
Dollar, pound euro rupee and so on.
I want to put command and decimal points as per the country specific formats.
I have tried using regional settings. But it has not worked as per my requirement
Hope you understand my requirement
Please guide
Manoj P Chakerwarti
If we want to add fluctuating cell what to do like example previous value of cell +new value of cell
Very good video
Thanks
Please can you guide about to add trailing zero in excel using custom formatting please
Mera ek bhut important question hai
Positive number blue color hoga or percentage value red color hoga help plz
👍 thank you....
sir app zoom kr k kaam kr rahy ho tou nazar nai aa rrahy hai ziada chezeen, aor ziada cheezen aoky sar k pechy rahty han ,tou kindly camra wala option uopar rakho gay tou insha allah agy vedios ma bahtareen kaam hoga,but thank you so much for detailed explanation
🙏🙏🙏 spectacular
Scatter with smooth lines and markers char may keyse x axis mey number ke jaga text add Karu...?
Thank you very much
You are welcome
Thanks
Sir number to color ho jata hai but number ke saath saath cell ko kaise color kare through custom (jaisa ki aapne bataya red karna hai to bracket me red likhenge)agar fill se color apply karte hai to number positive ho ya negative sab pe same hi color apply ho jata hai
mashallah🖤
Sir,any particular course for custom formatting
Thank you so much....can I apply formula in custom formatting? Basically I want value to be shown in crores...i.e. if I enter 2,00,00,000 then excel should display 2 CR... thanking you in advance..
Try : [
create format 0:0:0 allow negative number as well
12'4"*10'7" is ko multiply karne ke liye kaise formula lagaye plz batao sir
Neche bale option ke liye video😊
Thanks for this video sir, Voice is lil breaking, And your Self Video is covered worksheet area when you`re teaching about same
Yes Madhu, i habe improved the quality since then. Hope you will find decent quality contant on my channel now :)
@@learnwithlokeshlalwani happy to hear from you
Sir, hum kyese cell main ek date input karein aur automatically date/month/year aa jayye?
How can I copy the custom formatting into an excel sheet.
QUINTAL.KGS.GRAMS ke liye QTL 4.56.800. esa likha aye ke liye code formatting chahiye thi sir.🙏
SIR KIA TEXT KA LIA B MUJHAY NUMBER WRITE KARNA PARA GA YA WO PLACE HOLDER SA HO JAY GA
Freelancing work process bataye
Sir, any form created by us we use in our worksheet and then if we send that worksheet to any body by mail or pen drive etc. I mean if we use that excel worksheet to other PC then it sheet will use that same formates ??? If yes then good but if No , then what to do... ??
sir how to write 05-05-2023 ko only " 0523" for more data....in excel please in Number format
thx u sir great sir this lecture
Hi Ali,
Glad you liked the video :)
Also you can join my free Excel course here
learn-with-lokesh-lalwani.thinkific.com/courses/Freemium-Excel-Course
Happy Learning :)
Sir please explain how to convert the number in Indian Rupees format
What if I want an email field......@ should always appear?
Sir mjhe excel me agar time aye to use bhi accept krna h pr positive aur negative bhi sath me dekhna h
How can i include all these formating in one
nIC , SIR .....
Sir, I want to switch the percent or number to decimal automatically in a particular cell. From the Advance option, it applies in all cells. But I want it in only one cell. Eg. if I enter 50, it has to show 0.50 in particular cell not globally.
Hi Lokesh, Can you help me in making a custom format for Indian currency representation, for ex, 2280900 should show up as 22,80,900. by the way thanks for putting this up.
Hi sir ....agr mujhe seconds mai data chahiye as required in bpo always .....to custom mai kaise kre sir please.....guide once...
sir can we add a mathematical function during formating the cell?
Yes you can
thoda bahut samajh aa gaya. but logic clear nahi hua. aap is par ek detailed video laayen
How to Convert Numbers into Lakh & Crore - Excel Tricks & Tips #excel
ruclips.net/video/ICL15ALV9Gs/видео.html
thanku so much !
hi lokesh, your video is great. Is it possible to share how to share the numbering from Indian to International for example 10,00,000 to 1,000,000 format (example 10 lakh is 1m in international numbering system)
Dear friend, aap ka channel really bohat sikhane wala he, but aapki ki video ki waja se seen nahi ho saki detail, jis pe aap ki video thi.
Please avoid the issue for your further videos
How to add kg ltr etc in the right and left also in the particular no.
I want to know about default Date format dd.mm.yyyy from any other date format example . dd/mm/yyyy or dd-mm-yyyy etc...
last wala clear nhi hua sir ji apka video window show ho rha tha wahan per.
hi i want to know how to get the microsoft certified??? from where can i take this course
Hi,
There are two level of Microosft certifications on Excel.
1. MOS (Microsoft Office Specialist)
2. Expert Level.
You can simply visit certiport.pearsonvue.com/Home.aspx and search for the desired certification. As certiport takes care of all MS certifications.
My recommendation: I have an in-depth course on Excel, which covers all the functions and features required to clear the above two mentioned exams. This course targets both of these certifications. Here is the link for the same: learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass
Rest if you find any issue, ill be happy to guide you in the process of getting certifications as well. As i have done both :)
All the best :)
Lokesh Lalwani
i have faced a problem in Excel like I have put a formula & After that I want to remove Special character from formula cell amount
Hello sir ,How to save this changes which are done using format cell ?
Sir very helpful video but still I sm facing to write (0.05)% in excel custom.. sample automatically changed to (0.15)% please help
Do watch my playlist - ruclips.net/video/_094Nz4Yprs/видео.html&ab_channel=LearnwithLOKESHLALWANI
Thank you, Sir.
I want learn Excel format in explain pl guide me
Join my free webinar. here all your doubts will be cleared. Here is the link to register and join: event.webinarjam.com/register/13/m4851s2
Can you please tell how to convert numbers into lakhs and crore format? Million and bullion is already there.
Your face is hiding sometimes many of your important suggestions, pls brother,👍👍
Thanks.... surely take care next time :)
I have also same complaint/suggetion for data hidden by tutor face .
Sir mujhe is 20:14:16 me sate Krna hai sirf no. Dale or is format me aa jaye plz bataiye
How to put , commas, to display thousands laks and crores?
What about changing cell that have $5.04M to full number
Thanks for excellent presentation! I want to make excel worksheets for making engineering calculation. how to make a cell format combine for meter, feet, yard, numbers likewise. I mean when I enter a quantity in a cell it should come as per the description in left column. (ie, Meter (meters) (yard, Yards) (No, Nos)
Thanks. I have forwarded your query to Mr. Lokesh.
Meanwhile if you are going to work on excel for a long time in future then you can enroll for our Masterclass from the link. It will save you hours of time and will help you progress in your career. learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass
Sameer
Team Learn with Lokesh Lalwani
In eng. How we wrote inch fit.
I have to place two zeros after inserting number in general for exact value suppose I have to type 17500 but instead of this I have to type 1750000 two extra zeros for 17500. Please advice
When we create a custom formula, is there any way to save it for future use in the different workbook ( it gets added in the list)
If I use negative in red but if zero value shows with 0. I want to supress that zero. How can I do?
How can we colour specific text in a cell,
Example :-
1. Sum Of Amount
2. Sum of Data
3. Sum of Visit
I want to colour only text "Sum" wherever it is written and rest of the text (of Amount, of data, of visit) should remain in Black.
excel me formula koansa laga hai Ye kaise pahchane
matalab kya guna karake ya sum karake formula banaya hai ye samze
how to convert numbers to Lakhs. please help
How to change word and number color in a single cell?
For kilo we use 1 comma,for Million we use 2 comma.What will be formula if we want to write number in lakhs?