Number Format
- Format › Cells
- Toolbar
- Pane › Cells
Chooses how the values in the selected cells are shown, from plain numbers to dates and currency. The stored value never changes, only its appearance.
- Select the cell or range you want to format.
- Open the Number Format list: under each format you see the active cell's value in that format.
- Choose the format you want, or More Number Formats… to open Format Cells.
Tip Because formatting is display only, a figure that looks rounded still calculates with all of its digits.