Reference: Creating spreadsheets
Quattro Pro has default date and time formats. In addition, Quattro Pro has guidelines for entering years in two digits and entering dates prior to 1900 and after 2000.
Quattro Pro also has a lists of seed values and their sequences available for use with QuickFill.
Default date and time formats |  |
While Quattro Pro reads dates and times as values, it applies specific formatting and calculation criteria to them depending on the date and time criteria you set as defaults. When you type a date, the cell formatting automatically switches to the date format you typed. You can enter dates and times in any default date and time format.
|
•
|
|
The short international date format is ordinarily MM/DD.
|
|
•
|
|
The long international time format is ordinarily HH:MM:SS (13:42:30).
|
|
•
|
|
The short international time format is ordinarily HH:MM (13:42).
|
|
•
|
|
A date or time can be changed to another format.
|
|
•
|
|
International date and time formats are set by clicking Tools
 Settings, and clicking the International tab. |
Entering dates | |
Quattro Pro has specific rules for entering dates, including entering years in two digits, dates prior to 1900, and dates after the year 2000.
Entering years in two digits
If you enter a year using two digits, Quattro Pro assumes the century based on the following year ranges:
For example, the date 4/26/99 is interpreted as 4/26/1999. The date 2/2/25 is interpreted as 2/2/2025. To override the year assumption, enter all four digits for the year; for example, 4/26/1927.
Entering dates prior to 1900
If you enter a negative serial date value (for example, for a date before December 30, 1899) and reformat it as a date, to properly display century information you should set your system to the four-digit Windows default setting, click Format Selection properties and click either the Short date int
ernational (11/15/1899) or Long date international (Wednesday, November 15, 1899) date format.
Other standard and user-defined four-digit display options do not display the century information properly for negative serial date numbers.
QuickFill seed values | |
When you use QuickFill, sequences are available for specific seed values. These sequences allow you to automatically fill cells.