Changing the number formats on the spreadsheet
To change the number format used for a spreadsheet column:
- Right-click on the
column heading and select Column Properties
from the shortcut menu.
- You can make the following
formatting changes to numbers:
- Select how many
digits appear after the decimal point for the selected numeric column.
Values are truncated (not rounded) at the specified number of digits.
- Display negative
numbers in red.
- When you finish, click
[OK] to save your changes.
Tips:
- The above options apply only
to numeric columns.
- You can also change number
formats in the Modify Spreadsheet Layout window (Home tab > Spreadsheet group, or in classic view, View menu > Spreadsheet Layout).