How do you change the number format in Excel? | How do I create a custom format in Excel (हिंदी में)

👉 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 - [e-mail], [e-mail]
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

[@learnwithlokeshlalwani]

Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥

[@rajakhan-lt9fh]

Muje lack ke baad coma laga na hai kese lagaoo

[@iZacq]

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 ?

[@chandras260357]

More explanation is needed in this custom formatting. particularly those pre-designed and shown by excel in its custom formats field.

[@mushiburrahamanmallick1408]

you really deserve like, comment and subscription. subscribed

[@shahibaazkhanwhistlebreake7884]

Thank u so much Brother 👍aapne bahut acche se explain kiya😊👍

[@learnwithlokeshlalwani]

Glad you liked it :)

[@MONUYADAV-ue8fm]

Sir, Video is realy good. Thanku so much

[@AP-gr4ij]

Sir bahut achha samjhaya

[@deepaksahu-nf1vb]

Life saving tips

[@rehantahir4542]

Please guide complete date formatting in video that how to apply formatting on random dates in column

[@lookingforwardto]

bro, it is the best video in custom formatting in excel. thank you from Bangladesh. BTW where are you from?

[@learnwithlokeshlalwani]

You are welcome

[@krtikeymishra8176]

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

[@shubhamdogra5386]

#","###","###

[@manojkharsel2872]

Mera b same problem

[@gangadharbhardwaj]

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

[@ujjaldas646]

Scatter with smooth lines and markers char may keyse x axis mey number ke jaga text add Karu...?

[@fazalrashidalam4652]

Mera ek bhut important question hai Positive number blue color hoga or percentage value red color hoga help plz

[@HariOmSharma-p4t]

Thank you very much sir to put this much effort selflessly

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@Adityakumar-it8bx]

Very nice Lecture aapka samjhaane ka tarika bhut hi acchha hai.

[@learnwithlokeshlalwani]

Thanks SK.

[@raviadisare]

नमस्ते सर, अपने Custum Number Format के बारे में जो जानकारी दी बहूत ही अच्छी दि है | सर मुझे Custum Format में हेक्टर - आर - प्रती ( 01 - 40 - 9 ) का ऐसा फॉर्मुला बनाना है |

[@zaighamabbas3814]

Salam sir, plz told about data transfer from petty cash to other expsense sheet , office exp, bills, photocopies, etc

[@copatrade1465]

sir aapki aavas bahot aachchhi aur clear hai video record karte samay aap konsa mic use karte ho please bataiye ga.

[@ragib_23]

Great video sir thank you so much!

[@learnwithlokeshlalwani]

Glad it was helpful!

[@surjeetdhiman6612]

QUINTAL.KGS.GRAMS ke liye QTL 4.56.800. esa likha aye ke liye code formatting chahiye thi sir.🙏

[@azrairfan9898]

Please make a video on time difference calculation in hours and how to generate serial no. automatically in next row

[@manojchakerwarti]

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

[@fantasycollection5383]

If we want to add fluctuating cell what to do like example previous value of cell +new value of cell

[@laxmanbhardwaj2554]

sir how to write 05-05-2023 ko only " 0523" for more data....in excel please in Number format

[@jayganesh1079]

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.

[@kumarkailash7297]

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

[@vasurastogiallinone-alltyp4357]

Sir Ek Custom format complete banake samjhayie

[@nravikiran4661]

create format 0:0:0 allow negative number as well

[@tamimgamer1687]

Sir make a video in which all conditions should be apply . Like freeze , filter,count , vlookup,table many more

[@satyajitchatterjee3713]

Sir, hum kyese cell main ek date input karein aur automatically date/month/year aa jayye?

[@mariantonys]

Dost, you explained very well, but you could have put your video run on the left side

[@s.v7214]

thoda bahut samajh aa gaya. but logic clear nahi hua. aap is par ek detailed video laayen

[@khaniroey1573]

I understand a lot of things from this lecture so thanks sir 🙏

[@learnwithlokeshlalwani]

Thanks you Khani :)

[@yogeshkumar7749]

badia topic tha sir... ek bari me samjh aa gaya

[@learnwithlokeshlalwani]

Thank you so much for your comment. Glad you liked it!

[@wajidali7117]

Please can you guide about to add trailing zero in excel using custom formatting please

[@CricsShorts.01]

SIR KIA TEXT KA LIA B MUJHAY NUMBER WRITE KARNA PARA GA YA WO PLACE HOLDER SA HO JAY GA

[@cricketviratian9017]

Ispar firse ek video banaiye sir

[@sonali2720]

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

[@danceworld8646]

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

[@kkk8708]

sir apke jald hi 1m se upar ho jaye

[@naveenkarthik3305]

How can I copy the custom formatting into an excel sheet.

[@aakashpoint6848]

Thanks for your knowledge explore 😊👍

[@sucharitakundu8721]

Sir Conditional format ki ek pura video banaaiye sir

[@VijaySharma-tl3st]

Nice, Unknown basic fundamentals.

[@AKS-e6j]

thank you, sir (very useful information)

[@learnwithlokeshlalwani]

Glad it was helpful!

[@vivekmusafir4492]

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..

[@mehboobhussain3580]

It's very nice

[@unlimitedGK-om8bs]

🙏🙏🙏 spectacular

[@bhausahebsakurkar210]

Thank you for such valuable videos, sir can we custom format cell containing text with different colors.......please explain, thanks

[@babuhkonameti4294]

Thanks sir 🙏

[@arjun-m5c2f]

What if I want an email field......@ should always appear?

[@ghulamakbarsoomro3112]

Excellent

[@dronsahu6595]

Freelancing work process bataye

[@kamal448]

👍 thank you....

[@MohitSharma-fs8gc]

Hi sir ....agr mujhe seconds mai data chahiye as required in bpo always .....to custom mai kaise kre sir please.....guide once...

[@shankarpednekar8540]

How to insert comma when convert number in thousand

[@shaliniagrawal9554]

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

[@sachinkishore4115]

Thank you very much

[@learnwithlokeshlalwani]

You are welcome

[@sachinjawalekar4542]

Sir please explain how to convert the number in Indian Rupees format

[@kamal448]

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...

[@AmitPal-id7xx]

last wala clear nhi hua sir ji apka video window show ho rha tha wahan per.

[@populargaming9298]

Many many thanks sir jee u are great

[@babulkumar846]

Sir mujhe is 20:14:16 me sate Krna hai sirf no. Dale or is format me aa jaye plz bataiye

[@manishchandra9725]

Neche bale option ke liye video😊

[@SurendraSingh-jj9gf]

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.

[@shailjapoddar9047]

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?

[@nehanagpal378]

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.

[@chandramohan6072]

Nice sir.

[@abhaysattikar6349]

Sir very helpful video but still I sm facing to write (0.05)% in excel custom.. sample automatically changed to (0.15)% please help

[@learnwithlokeshlalwani]

Do watch my playlist - kzbin.info/www/bejne/lWGcZYGwab6jqNU&ab_channel=LearnwithLOKESHLALWANI

[@amirsiddiqui3092]

12'4"*10'7" is ko multiply karne ke liye kaise formula lagaye plz batao sir

[@prakashsahu4058]

How to add kg ltr etc in the right and left also in the particular no.

[@rakeshsukhija4613]

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

[@socialicdskgl2096]

Very good video

[@learnwithlokeshlalwani]

Thanks

[@Flxxer444]

*12,34.00* isko1234 me kase likhnyain in Google excle आगे पीछे स्टार लगा हुआ है

[@LawSchool1947]

Really Good

[@learnwithlokeshlalwani]

Thanks

[@bipenrai6144]

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

[@chigozieemeafu4415]

What about changing cell that have $5.04M to full number

[@swatantraranjan5112]

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)

[@fazalrahman8485]

sir can we add a mathematical function during formating the cell?

[@learnwithlokeshlalwani]

Yes you can

[@AliHassan-dz3ro]

thx u sir great sir this lecture

[@learnwithlokeshlalwani]

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 :)

[@hemajoshi735]

Sir I want one no like 12533422 In this format 1,25,33,422 Pl tell how to adjust thousand separator

[@cadskills4372]

how about keeping this in same cell (@ ₹ 2,461.00)

[@Jigyanshoo]

Can you please tell how to convert numbers into lakhs and crore format? Million and bullion is already there.

[@chandras260357]

How to put , commas, to display thousands laks and crores?

[@ansirqureshi4789]

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

[@khemantrao148]

Sir,any particular course for custom formatting

[@durgimajhi1629]

nIC , SIR .....

[@justforyou876]

Thanks

[@sairambokil7299]

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

[@sushiljoshi9211]

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... ??

[@mmuurrtthhyy]

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?

[@hameedchaudhry7060]

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)

[@drana58]

If I use negative in red but if zero value shows with 0. I want to supress that zero. How can I do?

[@arshadmehmood1256]

superb

[@chetanck2007]

how w to convert numbers in hundred values

[@orca4037]

In eng. How we wrote inch fit.

[@statusaddiction6742]

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.

[@ManojKumar-rm9pi]

Sir for example 1233470 covert in lakhs 12.33 ok. And 1012470 is 10.12. when we add number than answer is 2245940 in lakh=22.46 but 12.33+10.12=22.45 how maintain the difference and get correct answer

[@akankshamultiservices3290]

excel me formula koansa laga hai Ye kaise pahchane matalab kya guna karake ya sum karake formula banaya hai ye samze

[@mybestbuddy6682]

hi i want to know how to get the microsoft certified??? from where can i take this course

[@learnwithlokeshlalwani]

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

[@muhammadmuneeb-ur-rehman2913]

I am from pakistan... I face a problem in my office. i copy an account number from my office software, and i paste it in excel so it shows me in number with + symbol, i convert it in numbers but numbers become Change , i want that account number which i copied... How can i fornat it