[FREE EXCEL COURSE] Lesson 8 - Number Formatting in Excel

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 KZbin 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: kzbin.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@ellisiverdavid7978]

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! 😊

[@trumpexcel]

Haha... True :) I hope no one use that format! Thanks for the kind words. I am glad you're finding the courses useful

[@mr.gamingplays3827]

@@trumpexcel how was that quote related to humor at all , but it is true he is the best online teacher i ever had:)

[@rwpverhoeven]

I loved the custom number formatting. Thanx.

[@wayneedmondson1065]

Hi Sumit.. thanks for this video. I was not aware of using conditional operators (>,

[@rajeshmanori3851]

Please keep uploading videos.. and thank you so much for Free Excel course. thanks once again.

[@mohanvaze1]

I loved the custom number formatting. Thanks a lot

[@user-kb7ly8yi6b]

so good at teaching, and funny too! thanks so much for these

[@thaddcorbett2148]

Holy cow you know so much about custom formatting that I'm starting to you think you created Excel!

[@mishraamukesh]

Custom formatting..... Superb. Thank you.

[@vadimrudakov8907]

Thank you very much, Sumit!

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@mehdijj4550]

Perfect videos thanks for it

[@suchala]

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 !

[@SndfOmar]

Thank you Sumit. I wish you'd explained what the # or ? characters mean, as apposed to the 0 character.

[@rajveeryadav3473]

16:00 applying colours in different numbers

[@arenneagolen8551]

What happens when the student's grade is 35? (for the [

[@lky0929]

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!

[@Sandydutta1996]

Can this custom format apply for group of number?

[@jaweriamughal3347]

I am unable to implement formatting on date. I have tried too many times, can't understand the problem

[@shahnawazahmad4104]

How to write number 1. Or 2.? How to use this point?

[@lukechang2698]

Why doesn't some cells follow the custom formatting?

[@bholaincanada8547]

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?

[@heeyaboruah9226]

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

[@priyanshukumar2606]

Is this lesson from the year 2014?

[@BR-wi6ho]

Custom formatting could have been explained much better with some pre-feed random numbers.

[@bankramesh27]

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

[@heeyaboruah9226]

It is coming for me and I am using 2010

[@AjayYadav-nk7zf]

why Accounting will always be negative

[@financicalliteracyIND]

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❤

[@financicalliteracyIND]

@@jawstat8609 OKEY GOT IT

[@bhat_ias2965]

Are you IIT-CSE Sir?

[@tusharpatil96]

I typed 3.14 and it showed 31/7 as a result of fraction format😆

[@grandmasterace4785]

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.

[@medhavisshow4528]

us bro us

[@madahar107]

Hi Sumit You number formatting is out of focus.

[@MemeMunda-ct2fz]

Quality is not good... Need to improve plz...

[@utpalmohane1416]

Watch on 720p, then only it's understandable.....