Microsoft Excel tips
Friday, April 24, 2015
Decimal places
To have 2 decimal places displayed in numbers:
1. Select the column or row where the numbers should be displayed this way.
2. Click Home Ribbon->Number Gallery.
3. Click the Small arrow at bottom right of the gallery.
4. Format Cells dialog box pops up.
5. Number Tab
6. Category Number (second in list).
5. Decimal Places box = 2.
Subscribe to:
Posts (Atom)