How do you change the number format in Excel? | How do I create a custom format in Excel (हिंदी में)
ฝัง
- เผยแพร่เมื่อ 6 ก.พ. 2025
- 👉 FREE Excel Webinar. REGISTER NOW
event.webinarj...
In this video we will talk about “How do you change the number format in Excel?|| How do I create a custom format in Excel? (हिंदी में)”.
=========================================================
Download Excel File: learn-with-lok...
=========================================================
For any training requirement - trainingbylokesh@gmail.com, info@nurturetechacademy.in
Or
Visit: www.nurturetec...
=========================================================
In this video I have answered the following questions:
How do you change the number format in Excel?
How do I create a custom format in Excel?
how do I permanently create a custom number format in excel
different number formats in excel
excel number format formula
excel custom number format multiple conditions
how to change the number format in excel
excel custom number format millions
excel custom format add text after the number
excel custom number format thousands
===================================================
LIKE, SHARE, COMMENT, SUBSCRIBE TO MY CHANNEL, PRESS THE BELL ICON
For more such videos subscribe our channel: www.youtube.co...
Follow me on my Instagram for the latest updates: www.instagram....
#learnwithlokeshlalwani #nurturetechacademy
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
Sir,
Video is realy good. Thanku so much
badia topic tha sir... ek bari me samjh aa gaya
Thank you so much for your comment. Glad you liked it!
Very nice Lecture aapka samjhaane ka tarika bhut hi acchha hai.
Thanks SK.
Excellent
sir aapki aavas bahot aachchhi aur clear hai video record karte samay aap konsa mic use karte ho please bataiye ga.
Thank u so much Brother 👍aapne bahut acche se explain kiya😊👍
Glad you liked it :)
🙏🙏🙏 spectacular
Thank you very much sir to put this much effort selflessly
Thank you so much for your comment.
Life saving tips
Thanks sir 🙏
Many many thanks sir jee u are great
👍 thank you....
superb
Nice sir.
It's very nice
Really Good
Thanks
Hi Lokesh Sir
Nicely explained video in detail, & thanks. After seeing this video, I have tried to use special characters from @ to fraction symbols, but these symbols are not working in my system. Can you please explain?
Will wait for your reply.
Thanks
Amit Jain
Thanks for the information sir ❤️
thank you, sir (very useful information)
Glad it was helpful!
Great video sir thank you so much!
Glad it was helpful!
Salam sir, plz told about data transfer from petty cash to other expsense sheet , office exp, bills, photocopies, etc
Very good video
Thanks
Sir jaise hm conditional formatting se balance sheet ki values ko thousand mai kr skte hai but uske bad jo hmare pas nagative sign wali jo value hoti h unhe hm brackets m krna hai to hme kya krna chaiye jisse hmari value braket or thousand dono m ho jaye plz explain it?
mashallah🖤
नमस्ते सर,
अपने Custum Number Format के बारे में जो जानकारी दी बहूत ही अच्छी दि है | सर मुझे Custum Format में हेक्टर - आर - प्रती ( 01 - 40 - 9 ) का ऐसा फॉर्मुला बनाना है |
Please guide complete date formatting in video that how to apply formatting on random dates in column
bro, it is the best video in custom formatting in excel. thank you from Bangladesh. BTW where are you from?
You are welcome
Nice, Unknown basic fundamentals.
Please make a video on time difference calculation in hours and how to generate serial no. automatically in next row
Mera ek bhut important question hai
Positive number blue color hoga or percentage value red color hoga help plz
Please can you guide about to add trailing zero in excel using custom formatting please
Thanks you so much sir
Most welcome
nIC , SIR .....
Scatter with smooth lines and markers char may keyse x axis mey number ke jaga text add Karu...?
Dost, you explained very well, but you could have put your video run on the left side
Sir Conditional format ki ek pura video banaaiye sir
Thank you for such valuable videos, sir can we custom format cell containing text with different colors.......please explain, thanks
Ispar firse ek video banaiye sir
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
Sir, hum kyese cell main ek date input karein aur automatically date/month/year aa jayye?
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
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 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,any particular course for custom formatting
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
Sir Ek Custom format complete banake samjhayie
thanku so much !
🙏🙏🙏🙏
last wala clear nhi hua sir ji apka video window show ho rha tha wahan per.
SIR KIA TEXT KA LIA B MUJHAY NUMBER WRITE KARNA PARA GA YA WO PLACE HOLDER SA HO JAY GA
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
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...
Hi sir ....agr mujhe seconds mai data chahiye as required in bpo always .....to custom mai kaise kre sir please.....guide once...
How to add kg ltr etc in the right and left also in the particular no.
I understand a lot of things from this lecture so thanks sir 🙏
Thanks you Khani :)
How can I copy the custom formatting into an excel sheet.
What if I want an email field......@ should always appear?
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
Freelancing work process bataye
12'4"*10'7" is ko multiply karne ke liye kaise formula lagaye plz batao sir
Neche bale option ke liye video😊
sir how to write 05-05-2023 ko only " 0523" for more data....in excel please in Number format
Sir make a video in which all conditions should be apply . Like freeze , filter,count , vlookup,table many more
sir can we add a mathematical function during formating the cell?
Yes you can
QUINTAL.KGS.GRAMS ke liye QTL 4.56.800. esa likha aye ke liye code formatting chahiye thi sir.🙏
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
Yes
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.
Sir please explain how to convert the number in Indian Rupees format
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
Hi sir,
I need your help
I have some data in different boxes.
Ex
1A have some name - car v
2A have some kilometers - 5000
3A have some time in time format like - 12:12:10
4A I used &" "& this formula sad merge all 1A, 2A, 3A so it show - car v 5000 4.000 so all data merge but time did not come properly due to time format how I can love this.
I need merge all data
Thank you, Sir.
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
th-cam.com/video/ICL15ALV9Gs/w-d-xo.html
Sir mujko report card mai Mark's or grace Mark's ko 23+5 is tarah show kerna ho to kese ker sakti hu .report card lookup format se banaya hai
create format 0:0:0 allow negative number as well
Sir mujhe is 20:14:16 me sate Krna hai sirf no. Dale or is format me aa jaye plz bataiye
Use [h]:mm:ss
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
sir how to formate as crore
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 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 - th-cam.com/video/_094Nz4Yprs/w-d-xo.html&ab_channel=LearnwithLOKESHLALWANI
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
how w to convert numbers in hundred values
In eng. How we wrote inch fit.
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.
How to format in rs with comma separator
How I can fill sequence no
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
Hello sir ,How to save this changes which are done using format cell ?
excel me formula koansa laga hai Ye kaise pahchane
matalab kya guna karake ya sum karake formula banaya hai ye samze
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.
Thank you
Thanks Anil.
Here is a FREE Excel Course 👉👉learn-with-lokesh-lalwani.thinkific.com/courses/Freemium-Excel-Course
Dont forget to sign up :)
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)
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)
Can you please tell how to convert numbers into lakhs and crore format? Million and bullion is already there.
I want to type date in a cell without special character, after enter the cell format should change to date format eg: 03112021 to 03 NOV 2021 in the same cell, how can i customise this?
If I use negative in red but if zero value shows with 0. I want to supress that zero. How can I do?