Spread Designer
To format a number cell
In the Spread Designer,
- Select a cell or block of cells.
-
Choose the cell type using one of the following methods:
- Display the pop-up menu by right-clicking the cell or block of cells and then choose Number.
- From the Cell menu, choose Cell Type, Number.
- Choose the Number button ( ) on the cell type toolbar.
The Cell Type dialog box appears. -
In the Cell Type dialog box, on the Settings tab,
- If you want to specify a custom separator character, type the character in the Separator Symbol box and select the Show Separator Symbol check box.
- If you want to specify a custom decimal symbol, type the symbol in the Decimal Symbol box.
- If you want to specify whether a leading zero is displayed for values between 1.0 and –1.0, choose an item from the Leading Zero drop-down list box.
- If you want to specify a different format for negative values, choose an item from the Negative Style drop-down list box.
- Choose the OK or Apply button.