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.
Click to quickly change the number of decimal places displayed.
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 formatting styles, or you can apply different types of formatting individually. Some of the individual formatting styles you can choose include