Spread Designer
To create and customize a currency 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 Currency.
- From the Cell menu, choose Cell Type, Currency.
- Choose the Currency button ( ) on the cell type toolbar.
The Cell Type dialog box appears. -
In the Cell Type dialog box, on the Settings tab,
- Type the maximum value for the cell in the Max Value box.
- Type the minimum value for the cell in the Min Value box.
-
Type the number of digits that can be typed to the right of the decimal place in the Decimal Places box.
Note: The total number of digits to the left and right of the decimal symbol cannot total more than 14. - If you want to display a separator character, select the Show Separator Symbol check box.
- Specify how the data is horizontally and vertically aligned in the cell by selecting an option button under Horizontal Alignment and Vertical Alignment.
- Specify how text is oriented in the cell by choosing an item from the Text Orientation drop-down list box.
- Choose the OK or Apply button.