Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
The ability to format numbers in Excel is really one of its powerful features. If I click over the cell E4, and I go up to my number group on my ribbon, I can easily change the layout of that particular cell and include different numbering formats with clicks of bottoms here as well as a drop-down list from the top. If we go back to our buttons, It would allow me to add decimal places just with the click of a button. So If I hover over my first Increase Decimal button here and just click, I've added 1 decimal place.
Also notice that it's adjusted size of the column at the same time. If click again, I end up with two decimal places, so it's very, very easy to add decimal places or remove them, by selecting the other Decreased Decimal button. I can add commas, I can put in percents, if I click this on the percent, it changes that particular formatting to not be a dollar formatting but to be a percentage. Let's just undo that by clicking up on the Quick Access toolbar to do that change. So I'm brought back to where I was before.
And I also have some currency formatting I can change from the United States dollar value, over to the pound in the UK and the Euro if I wanted to see the similar formatting. And it gives me the correct sign for that particular currency as well. If I click on my downward arrow up here, you'll see that there are lots of other options that I can work with, in terms of my numeric. I can identify currency, I can work with accounting for whatever particular country I'm working in, I also have some date choices as well as times choices, and I have a custom choice.
If I click on the More Number Formats, I'm brought up with a very familiar screen for those of you that have worked in Microsoft Excel previously. If I click on the custom area here, you'll see that there is all kinds of different options that I can do. And in this case, I can actually present the information in any format that I want. So you see that the ability to change the numeric formats, in Microsoft Excel 2007, is one the easiest things that you're going to be able to do with it. Next we're going to take a look at how you can align data in the cells, to present the information in a very readable format.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.