Why Are So Many Decimal Showing In Excel? Answer Student’s Question About Number Formatting
HTML-код
- Опубликовано: 22 авг 2024
- Mike excelisfun answers students question about number formatting for the Highline College Busn 210 - Excel and Statistics Class.
Thanks amazing Mike for this EXCELlent video.
You are welcome, Fellow Teacher!!!!
Sir I haven't seen such excellent channels in RUclips so for you are number one really can u make AI in excel because I stopped all other channels
I am a few months behind becasue my mom died and I had to take care of her. But I do plan to do an AI video that should rock the boat.
Thanks Mike. :)
You are welcome, Formula Guy John!!!!!
@@excelisfun, please given the excel files
Hello sir, when will you release the series of *DAME w MPT* at youtube ?
The first video will be out in about 35minutes. It is 6:16 PM Pacific Standard Time in US. I can't wait!!!!
Mike, Is still there EMT again ...❤
There has been EMT for 16 straight years, but when i am creating classes, there go on pause : ) The class I am creating now is DAME with MPT. I will post the first video in this class in about 10 minutes.
Waiting for a detailed “text” formatting video, focusing on the forth part of Text function ( +ve, -ve, zero, Text )
I have many videos about this already posted. Here is a play list with 103 videos:
ruclips.net/p/PLA8E169D01380A4F7
My fav TEXT formula of all time is:
ISO Date Into => Proper Date Formula:
20240522 5/22/2024 =TEXT(B20,"0000-00-00")+0
@@excelisfun thanks for the efforts, but all of them are for number formatting, Not the Text part 🥹
@@BaniMoniah Oooooo, that is too funny, I have basically never used the @ text part of TEXT. I am so busy now with creating RUclips classes and writing books, but when I am done, that will be the next video. Thanks for the great idea, Bani!!!!!!
@@excelisfun we had this conversation before 😂, but I’ll wait and see what we could get 👍🏻, all what I know in Excel is mainly from you and the great Excel is fun channel.
Please.sir mike also make a short glimpse on . sometimes we see % like 560.00, 750.0% which infact 56% ,75% what's the reason behind this details explanation same as you explain in the above video
I have made more than 100 videos on that topic. Here is one: ruclips.net/video/EJXI0Puf_oQ/видео.html (Excel Basics 9: Number Formatting as Façade & the ROUND Function). But it 100% comes down to one fact: Percents are not numbers. And the scary thing is that almost all people in the world do not know that. Look at Wikipedia about the evolution of %, it's pretty cool. Here is the answer to your question:
A percentage is a formatted representation of a number. A percentage IS NOT A NUMBER. For example, if the tax rate is 5%, that means that for every 1 dollar, the government tales 5 pennies. The number that represents those 5 pennies is: 0.05. And, as we learned in grammar school, how do you convert a number to a percentage?1) You multiply by 100, or slide the decimal 2 positions to the right. So 0.05 => 5. Right there: that is why percentages are not numbers. because 0.05 does not equal 5. 2) you add a % symbol to get: 5%. 5% represents the number 0.05, which means 5 parts out of 100, 5 pennies out of the 100 pennies in a dollar.
Back to your question. Why do you see 750% when you apply a Percent Number Format? Because the Percent Number Format obeys you. You type the number 75. The Percent Number Format engine slides the decimal two to the right to get 7500, then adds the symbol to get 7500%. This is in fact one of the most common errors in the 40+ years of Excel history. The good news is that if we know that a % format is a façade, a symbolic representation of a number, then we will always type 0.05 before you add the format or, just format as you type and type 5.00%. When you type 5.00%, Excel puts the number 0.05 in the cell and adds number formatting. Try it: type 5.00% and then apply the General Number Formatting to remove the formatting and BAM: 0,05 is in the cell.
I hope that helps : )
Great video Mike :):):)
Thanks, Nader : )
This is utterly facade which most of don't realize. I use Ctrl+ Shift+ ~ to remove formatting. 👍👍
That is a killer keyboard short cut : ) : ) I have used it just about every single day that I have used Excel
Hello sir, sometimes the number format for the dates or numbers which we get from csv or other files to excel doesn't work what is the best solution for the same?.
The answer is that is depends on the situation. There are so many scenarios. For example id you get an ISO date 20240407, and you want it as a proper date, in the Excel worksheet you would use the formula:
=TEXT(B20,"0000-00-00")+0
If date is in cell B20
Wait a minute… shouldn’t that be Ricola instead of Rico Lee?
And are your videos now sponsored by Swiss herbs throat bonbons?
…What do you mean “I misunderstood you”?
LOL! Just goofing. ;-)
L-O-V-E the goof. Go Team!!!!
why not post everyday if you can?
Because I work 10 to 16 hour everyday almost every day of my life since I was 19. I am 61 now. I LOVE the idea, but I just can't seem to EVER get any free time to do exactly what you say. Maybe when I retire : ) P.S. If I posted every day, I definitely would be breaking the law on having too much fun lol