[FREE EXCEL COURSE] Lesson 8 - Number Formatting in Excel
ฝัง
- เผยแพร่เมื่อ 5 พ.ค. 2019
- In this video of this Excel course, you will learn all about number formatting in Excel.
This video covers the following topics:
-- How to access number formatting options
-- Using number formatting options using a dialog box
-- Using custom number formatting
Remember that formatting a number in Excel only changes how it's displayed, but the underlying value remains the same.
☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: trumpexcel.com/learn-excel/
You can also access the Full Excel Training on TH-cam here: • Getting Started with E...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: th-cam.com/users/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
![[FREE Excel Course] Lesson 9 - Excel Formula Basics](http://i.ytimg.com/vi/Bv61rIeKsaI/mqdefault.jpg)
![[FREE Excel Course] Lesson 9 - Excel Formula Basics](/img/tr.png)
![[FREE EXCEL COURSE] Lesson 7 - Auto-fill, Custom Lists, and Flash Fill](http://i.ytimg.com/vi/JiRWjeYza9A/mqdefault.jpg)
23:00: "Now, no sane person would use this as their number formatting or their date formatting." 🤣
I'm so glad I found your channel! Your humor is as excellent as your clear demonstrations of Excel's capabilities that are usually followed by your practical tips about what actually works and what doesn't. Your way of teaching definitely manifests your mastery of this field! I'm looking forward to learning more from this series and also from your "Free Excel VBA Course" and "Free Excel Dashboard Course" within this month. Thank you so much for these exemplary videos, Mr. Sumit! 😊
Haha... True :) I hope no one use that format! Thanks for the kind words. I am glad you're finding the courses useful
@@trumpexcel how was that quote related to humor at all , but it is true he is the best online teacher i ever had:)
I loved the custom number formatting. Thanx.
Hi Sumit.. thanks for this video. I was not aware of using conditional operators (>,
Custom formatting.....
Superb.
Thank you.
I loved the custom number formatting. Thanks a lot
Perfect videos thanks for it
Thank you very much, Sumit!
Holy cow you know so much about custom formatting that I'm starting to you think you created Excel!
so good at teaching, and funny too! thanks so much for these
Thanks for the this course.
Mr. Sumith, It is worderful to learn so many new things in excel. I wanted to know how to enter Blood Pressure readings as they wll be like 140/80 or 170/110 in fractions. Thanks in advance !
Please keep uploading videos.. and thank you so much for Free Excel course. thanks once again.
Thank you Sumit. I wish you'd explained what the # or ? characters mean, as apposed to the 0 character.
What happens when the student's grade is 35? (for the [
Hi I have a question.. I have a table of numbers and some text. I want the numbers to be shown in black color while text (like A,B,C...) to be shown in red. Which formula should I type? Shouldn't it be "[Black][>=1]0;[Red]text" ? Many thanks in advance!
16:00 applying colours in different numbers
Can this custom format apply for group of number?
Why doesn't some cells follow the custom formatting?
How to write number 1. Or 2.?
How to use this point?
As you have said in your lesson 8 i tried with the short cut ctrl +1 but FOMAT CELLS DIALOGUE BOX is not coming, i am using office 2016, PLEASE AD ISE
It is coming for me and I am using 2010
I am unable to implement formatting on date. I have tried too many times, can't understand the problem
25:17 isn't it a 24-hour clock since you are talking about 18 which would fit into a 24 hour clock? I may be wrong but I am quite sure I am not🤨.
i didnt get that #?/? formatting,i want to know when u typed 0.1 it shows 0, not a fraction value why it is so?
Is this lesson from the year 2014?
21:24 ; SIR if i type 1.2 and then do fraction with #?/? we find 11/5 but how can it be, cause in real it should be 6/5 which comes when we do 0?/?. PLEASE CLEAR MY DOUBT❤
@@jawstat8609 OKEY GOT IT
why Accounting will always be negative
Custom formatting could have been explained much better with some pre-feed random numbers.
Are you IIT-CSE Sir?
I typed 3.14 and it showed 31/7 as a result of fraction format😆
It is showing 3 1/7. There is a space to show that 3 is a whole number and 1/7 is a fraction. And it all becomes 22/7 when converted to an improper fraction.
Hi Sumit You number formatting is out of focus.
Quality is not good...
Need to improve plz...
Watch on 720p, then only it's understandable.....
us bro us