Tip:
Highlight text to annotate it
X
Apply a Number Format.
You can make your worksheet easier to read by applying a number format to your data.
For example, if your worksheet includes monetary data, you can apply the Currency format to
display each value with a dollar sign and two decimal places. Excel offers ten number
formats, most of which apply to numeric data. However, you can also apply the Date format
to date data, the Time format to time data, and the Text format to text data.
Select the range you want to format.
Click the Home tab.
Click the Number Format .
Click the number format you want to use.
Excel applies the number format to the selected range.
For monetary values, you can also click Accounting Number Format.
For percentages, you can also click Percent Style.
For large numbers, you can also click Comma Style.
Change the Number of Decimal Places Displayed.
You can make your numeric values easier to read and interpret by adjusting the number
of decimal places that Excel displays. For example, you might want to ensure that all
dollar and cent values show two decimal places, while dollar-only values show no decimal places.
Similarly, Excel often displays values with a large number of decimal places. If you do
not require the extra decimals. For example, if the values are simple temperatures or interest
rates. You can make them easier to read by reducing the number of decimals. You can either
decrease or increase the number of decimal places that Excel displays.
Decrease the Number of Decimal Places.
Select the range you want to format.
Click the Home tab.
Click the Decrease Decimal button.
Excel decreases the number of decimal places by one.
Increase the Number of Decimal Places.
Select the range you want to format.
Click the Home tab.
Click the Increase Decimal button.
Excel increases the number of decimal places by one.