Spread Designer

To format a date cell

In the Spread Designer,

1. Select a cell or block of cells.
2. 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.
3. In the Cell Type dialog box, on the Settings tab,
   1. Select the date format from the Format drop-down list box.
   2. To display the year in century format, select the Display Century check box.
   3. Type the character that separates the day, month, and year in the Separator box.
   4. If you want to horizontally or vertically align the text, select the appropriate option button under Horizontal Alignment and Vertical Alignment.
   5. To display a spin button, select the Display Spin Button check box.
   6. Choose the OK or Apply button.