All language subtitles for 3. Formatting Numbers in Excel 2016

In this video you will learn how to format numbers itself was primarily designed to work the numbers

and as such has a large number of formatting options available for numbers.

To apply no format to a group of cells first select the cell range then in the number group click the

number Format dropdown and select number excel for matchstick contents as number and displays decimal

places by default.

A number is formatted as general some of the common Number Formats are no currency accounting date time

percentage and fraction.

You can also access the formatting options for number by opening the dialog box launcher in the number

group click the number that in the format cells dialog box select no option in the category list.

Excel displays formatting options for No.

You can control how a negative number is displayed in the cell.

You can increase or decrease the number of decimal places to display as you make changes.

What's the number in the sample box.

For the selected cells before to be 15 let us decrease the decimal place by a 1.

You can apply thousand separate bill by selecting that checkbox this option puts a comma after every

three digits from the right notice that in selected cells before to be 15.

Excel has decreased the decimal place by 1 and a comma appears after every 3 digit from the right.

Please note that increasing or decreasing the number of decimal places does not affect the way Excel

performs calculations.

For example nineteen point four five is displayed as nineteen point five.

Since we set the decimal places to 1 similarly twenty point four five is displayed as twenty point five

the actual number is displayed in the formula but but in calculations for example if this sum the two

numbers Excel will still use these numbers as nineteen point forty five and twenty point four five.

That is up to two decimal places.

You can notice that the sum of two numbers is thirty nine point nine and not forty four cells that represent

money we should use accounting number format or currency format Excel supports all standard currency

symbols used in the one you can display a number with the default currency symbol by selecting the range

of cells and then clicking accounting number format by default a currency sale has two decimal places.

If you want to apply the currency format instead select this is click the number format dropdown all

and select currency notice that when you apply the currency format to a number the currency symbol appears

right next to the first digit in the in Velez accounting format.

Align state currency symbols and decimal points off a number in a column.

To change the currency click the dialog box launcher next to number in the number group open the number

tab in the format cells dialog box then select currency in the category list in the simple dropdown

list.

Scroll down and select the currency you want.

Click okay to apply the formatting to the this.

You can also choose the desired currency prefix by clicking the dropdown at or of accounting number

format.

Click more accounting formats click the currency symbol list and select the currency you want.

You can format a number as percent in Excel to clearly identify a cell that represents a percentage

data let us calculate the discount inputs and date for the month of January.

Let's divide the discount amount by the price to calculate the percentage among type equal to select

discount cell divided by list price.

And press Enter select the cell and click the person style tool in the number group excel format the

cell est person if you wish to clear formatting of the cells click the clear button in the editing group

from the list.

Select clear format.