Formatting a Date Cell

---

• Spread Designer Instructions
• ActiveX Instructions
• DLL Instructions

Overview

By default, the currency cell uses the Windows regional settings for the date format. You can customize the date format by using one of the predefined date format options, as illustrated in the following table.

Date Format	Date Representation
28/NOV/98	DDMONYY
28/11/98	DDMMYY
11/28/98	MMDDYY
98/11/28	YYMMDD

You can also further customize the dates by customizing the separator character and by specifying whether the century value is displayed.

Note: If your date cell format displays only two-digit years, the control makes an assumption about the four-digit year value that corresponds to the displayed two-digit year value every time the century value is needed. If you choose not to provide four-digit year values and instead let the fpSpread control assume a century value, be aware that the control might extrapolate the century value using the method specified by the TwoDigitYearMax property or assume the value is Null. You must check the resulting century value to ensure it is the value you intend.

In addition, you can align the text within the cell. If you want, the cell can also provide a spin button to let users change dates quickly.