Excel Training in telugu Number Group Part3

Free Ms Excel Training in telugu

The Ribbon offers a simple way to apply number formatting. To customize number formatting, refer to Formatting Numbers: Dialog Box Option.

Select the cell(s) you want to format

From the Home command tab, in the Number group, click NUMBER FORMATNumber Format button» select the desired number format
The cell is formatted.
HINTS:
The default category is General.
The number in the selected cell is previewed under the format label in the pull-down list.

return to topFormatting Numbers: Dialog Box Option

The Format Cells dialog box can help you customize your number formatting.

Select the cell(s) you want to format

In the Home command tab, in the Number group, click FORMAT CELLS: NUMBERFormat Cells: Number
The Format Cells dialog box appears with the Number tab displayed.

From the Category list, select the desired number format
HINT:You can preview the formatting in the Sample section.
EXAMPLE: Select Currency.

If the format offers additional options, select the preferred options
EXAMPLE: Format the number of decimal places, the desired symbol, and negative numbers.

Formatting Numbers: Toolbar Option

When you want to format numbers quickly, Excel allows you to do so from the Ribbon.

1. Select the cell(s) you want to format
2. From the Home command tab, in the Number group, click the desired toolbar option

Name	Image	Description
Number Format		Displays the formatting style of the selected cell NOTE: For more information, refer to Formatting Numbers: Ribbon Option.
Accounting Number Format		Changes the formatting to Accounting NOTE: You can insert foreign currency symbols by clicking the.
Percentage Style		Changes the formatting to Percentage
Comma Style		Changes the formatting to include commas and two decimal places
Increase Decimal		Adds one decimal place to the selected cell
Decrease Decimal		Removes one decimal place from the selected cell
Format Cells: Number		Accesses the Format Cells dialog box