Numeric formats


show more Numeric formats provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Numeric formats

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

Numeric formats
Video duration: 2m 20s 5h 13m Beginner

Viewers:

Numeric formats provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...