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 ?
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
नमस्ते सर, अपने Custum Number Format के बारे में जो जानकारी दी बहूत ही अच्छी दि है | सर मुझे Custum Format में हेक्टर - आर - प्रती ( 01 - 40 - 9 ) का ऐसा फॉर्मुला बनाना है |
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 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 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
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?
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, 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.
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
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?
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)
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
Hello Sir, I used to maintain accounting data in a single column like debit and credit amount in a single column. I want to enter amount like this 10,000(Dr) or 10,000(Cr). I am always doing it manually but it takes a lot of time. Is there any easy solution for it?? I tried custom format cells but its automatically put (Dr) Or (Cr) sign to each and every amount. Please suggest an easy way to do it
Sir, if i want to fill a cell with a specific colour let say light green, then can i have shortcut like just alt+ h+h and something to directly choose that colour, bcos we have to go through navigation keys to select any specific colour
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 :)
On my laptop whenever I restart the system and open any excel which already saved the format automatically falls to Accounting from General..... Can anybody tell me how to fix this issue to keep General format ?
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
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
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.
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