en uk

Formatting decimal numbers Microsoft Office 2007

    If you format cells to display numbers with decimal places, such as 23.09 or 23.09185, you can modify how many decimal places appear. To define the number of decimal places, follow these steps:

    1. Select the cell or cells that contain the numbers you want to format.

    2. Click the Home tab.

    3. Click in the Number Format list box (refer to Figure 7-3) and choose a format that displays decimal places, such as Number or Percentage.

    Excel formats the numbers in your chosen cells.

    You can click the Increase Decimal (increases the number of decimal places displayed) or Decrease Decimal icon (decreases the number of decimal places displayed), as shown in Figure 7-7.

    Formatting decimal
numbers Microsoft Office 2007

    Figure 7-7:

    Click to quickly change the number of decimal places displayed.

    Formatting cells

    To make your data look prettier, Excel can format the appearance of cells to change the font, background color, text color, or font size used to display data in a cell.

    Excel provides two ways to format cells: You can use Excel's built-in format­ting styles, or you can apply different types of formatting individually. Some of the individual formatting styles you can choose include


Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.