Microsoft Office Tutorials and References
In Depth Information
Formatting cells containing numbers
Set the number of decimal places
1 Select the cells that you want to format.
2 Click the Home tab.
3 Follow either of these steps:
a Click the Increase Decimal button in the Number group on the
b Click the Decrease Decimal button in the Number group on the
TIP When you create a worksheet, you should apply the
numerical formatting that you want to all the cells in which
you’ll store numbers of a certain type. That way, when you type the
data later (or copy it from another document), it will be formatted