[FREE EXCEL COURSE] Lesson 8 - Number Formatting in Excel
HTML-код
- Опубликовано: 10 фев 2025
- In this video of this Excel course, you will learn all about number formatting in Excel.
✅ Download File - trumpexcel.com...
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.
✅ Download File - trumpexcel.com...
☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
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...
You can also access the Full Excel Training on RUclips here: • Getting Started with E...
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ 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: www.youtube.co...
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)
I'm so glad I found this channel, You are teaching me so much . I will have to send you two cups of coffee . Thank jj
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.
so good at teaching, and funny too! thanks so much for these
Hi Sumit.. thanks for this video. I was not aware of using conditional operators (>,
I loved the custom number formatting. Thanks a lot
Thank you very much, Sumit!
Thanks for the this course.
Holy cow you know so much about custom formatting that I'm starting to you think you created Excel!
Please keep uploading videos.. and thank you so much for Free Excel course. thanks once again.
Custom formatting.....
Superb.
Thank you.
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 !
Perfect videos thanks for it
Thank you Sumit. I wish you'd explained what the # or ? characters mean, as apposed to the 0 character.
16:00 applying colours in different numbers
9:05 custom format
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
Hey please explain how .1 became 0? #?/? shouldn't it be 01/10?
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?
thats hash entry .. so it doesn't consider 0, while if it was 0?/? then you would be correct.
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🤨.
Can this custom format apply for group of number?
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!
Is this lesson from the year 2014?
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
How to write number 1. Or 2.?
How to use this point?
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?
Are you IIT-CSE Sir?
Why doesn't some cells follow the custom formatting?
Custom formatting could have been explained much better with some pre-feed random numbers.
why Accounting will always be negative
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