Spread Designer
To format a date 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 Date.
- From the Cell menu, choose Cell Type, Date.
- Choose the Date button ( ) on the cell type toolbar.
The Cell Type dialog box appears. -
In the Cell Type dialog box, on the Settings tab,
- Select the date format from the Format drop-down list box.
- To display the year in century format, select the Display Century check box.
- Type the character that separates the day, month, and year in the Separator box.
- If you want to horizontally or vertically align the text, select the appropriate option button under Horizontal Alignment and Vertical Alignment.
- To display a spin button, select the Display Spin Button check box.
- Choose the OK or Apply button.