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

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.



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[ellisiverdavid]

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

[KimFrancesBamba]

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

[rwpverhoeven]

I loved the custom number formatting. Thanx.

[wayneedmondson]

Hi Sumit.. thanks for this video. I was not aware of using conditional operators (>, <, etc.) in custom formats. Also, like that [hh] trick for showing more than 24 hours in a time format. Great tips. Thanks and thumbs up!

[rajeshmanori]

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

[mohanvaze]

I loved the custom number formatting. Thanks a lot

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

[thaddcorbett]

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

[FsoOmar]

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

[arenneagolen]

What happens when the student's grade is 35? (for the [<35]"Fail" command)

[lky]

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!

[rajveeryadav]

16:00 applying colours in different numbers

[Sandydutta]

Can this custom format apply for group of number?

[GoGetSP]

so when we enter .1 at 21:23 and use custom formatting #?/? why doesn't it become 0 1/10? not able to understand this?

[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❤

[heeyaboruah]

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

[bankramesh]

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

[jaweriamughal]

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

[bholaincanada]

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?

[shahnawazahmad]

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