### Related posts:

- Excel Basics 11: Search for Excel Functions & get help with Function Arguments
- Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations
- Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)
- Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!

Accounting Number Format Busn 216 Complete Lesson in Excel Currency Number Format Erase all Number Formatting Excel Excel 2016 Excel Basics Excelisfun General Number Formatting Highline College learn excel Learn Excel for Free Learn Excel Online Michael Girvin Mike Girvin Number Formatting Façade Percentage Number Format ROUND Function ROUND Function for Invoicing ROUND Function for Payroll Round to dollar Round to penny What does Number Formatting do

Important stuff – thumbs up!

Trevi fountain! Nice analogy Mike! Reminds me about going back to Italy! Beautiful. And such an important lesson that just because 2 numbers appear to be the same doesn't mean that they actually are the same.

EXCELlent video. Thanks Mike, for all the impressive work you are doing.

Enthusiastic thumbs up! Would give it more than one if I could.

Nice to see you again Mike

Thanks for a great video – the links are for a different video?

Thank you so much Mr. Mike it is really fun

Thanks for this wonderful video, always a pleasure when you upload. God bless Mr Mike.

this is the example of NIK the citizen registration number in my country 7310054301130001

this is the formula to extract birth date of that NIK

=IFERROR(DATE(20-(MID($C3397;11;2)>RIGHT(YEAR(TODAY());2))&MID($C3397;11;2);MID($C3397;9;2);IF(VALUE(MID(C3397;7;2))>40;MID(C3397;7;2)-40;VALUE(MID(C3397;7;2))));"")

is there a short formula sir to replace that long formula to find birth date? because i just copy paste that formula and suit the cell refrence when i used it,, i my self did not trully understand the logic behind those formula

many thanks before,,,

Thank you Mike, although this is basic theory I learned a few things. I always just enter numbers and correct them later. This makes me more conscious about it.

One remark to %: this is a strange symbol, as far as I know this is the only symbol that is not a number but that you can enter in the formula: for example if you enter 5%, you will SEE this (%) in the formula bar as well. It will automaticaly convert to percentage. If you put it back to general then you see 0,05.

I also experienced something else: if you enter 5€ or 5$ in the formula bar, it will be adjusted to 5 and the format is currency. Is this new? I thought in previous versions Excel would save this as text. Anyway: Formatting deserves special attenion in all courses. Thank you again.

Interesting!! Thanks for your constant support and effort you give to all of us with your videos 🙂

Love this video on number formatting basics – all those custom formatting books behind you & general as eraser 🙂

Again an EXCEllent video, thank you! And here is a story – a tiny little recent glory at work, for which I thank you Mike:

It happened a few times in the past, that the accounting sheets I received daily from the billing guys were a penny or two off here and there – and since I have to receipt the amounts in our billing system, I had trouble finding the missing and/or overpaid pennies. Now here comes this video I have watched yesterday – straight this morning checked all the sheets for rounding errors, and sure as sunrise, there was the solution with the number formatting. Showed (off) to the boss, who could not thank me enough for the insight and I also had the delightful task to teach the billing guys of the ROUND() function.

Again, thank you for these videos!!!

How can we follow these tutorials in order. For example, it goes from tutorial 1 to 10 and then the numbers jump all over the place. Is there a way to see all the tutorials? I can see about 40 of them, when I click "Excells Fun" but since some of them have numbers in the thousands, there must be more than 40.

Thanks

Thanks for the video, excellent as usual. Do you have excel files that I can download which deal with this subject (number formatting)? Thank you once again.

Thank you

You're absolutely beautiful, sir!

great video guru ji!!!!!

The general information about number formating and use of the round formula will surely come in handy over time. Thanks for the video.

Good stuff. 😁👍

Thanks

Good useful tips, after all years of using excel finally learn rounding

Sir,

Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.

HEY MIKE, I have a question.

I have almost completed this basics series.

I want to learn intermediate-advanced data analysis for HR administration. What do u recommend next in your playlist?

This is my favorite video thus far, as I finally get to see – albeit briefly from 1:37 – 1:47 – the face behind the brains, energy, sincerity, and sheer hard work put into all these online resources 😉 Thank you so much Sir, and do keep these educational videos coming in! (It's rare I can find another media source to replace Netflix).

This video had some amazing concepts. I am on a binge watching and practicing from the resources you have shared and I find them excellent. Thanks a lot sir 🙂

Hello Mike and thanks for the amazing classes. I have been through years of health issues and finally trying to get back to work. Since mobility is limited and what not office work is what I'm looking at to get back to work with my friends appraisal company. Going out into the field gathering asset lists is where I like to be but along with that comes submitting a report on an Excel program UUUgh! all I can say is almost all my free time is devoted to your video's and even have let the tv play while I sleep HA! yeah I am desperate to learn fast so I can prove myself of value around here.

Anyway I have had some help from the Department of Rehabilitation with items I need to get back to work and up to speed with what it takes to get a job again (Thank God)!

So thanks again and for now I will be watching the basics over and over just to learn the terminology and functionality and look forward to moving up to the next video's. When I am getting by here at work with excel I will get my excelisfun swag, until then it

is intimidating. Your new online student Calvin

Who else’s accounting didn’t show negative in parentheses?

Is that Lakers hat I see? If so, right on! Anthony Kiedis and Flea approve too!!!

thanks a lot!

Saying thank you hardly seems enough after all you have done for us.

You are the best teacher ever, thanks a lot

Round functions really plays a major role in everydays life

Thank you so much sir

😀😀👍👍

always a pleasure when you upload. God bless Mr Mike.

what was that,i think I heard it right… wohoo wohoo Lol

The best Teacher IN THE WORLD! THANKSSSSS

hello sir, I loved your videos. In this video, I am facing a problem. In the accounting number formatting I the negative numbers are not in parenthesis but they are actually showing in the normal formats. ( I am using ms office 2010)