Corel wordperfect office 2002 ユーザーズマニュアル
formats you set as defaults. Dates or times can be in many formats, such as 04-04-98, 04/04/98,
and 01:42:30 PM.
Quattro Pro stores all dates as serial integers and times as decimal fractions, so that it can
Quattro Pro stores all dates as serial integers and times as decimal fractions, so that it can
calculate dates and times as values. The minimum serial integer is -109,571, which represents
January 1, 1600; the maximum is 474,816, which represents December 31, 3199. The minimum
decimal fraction for time is 0.99999 (for the time 23:59:59) and the maximum is 0.000 (for
00:00:00). The serial integer or decimal fraction appears in the input line when you select a cell.
A cell containing a serial integer mixed with a decimal fraction indicates the date and time. For
A cell containing a serial integer mixed with a decimal fraction indicates the date and time. For
example, 2.5 represents January 1, 1900 at 12:00 noon.
To enter a number
1 Click a cell.
2 Type a number.
3 Press ENTER.
2 Type a number.
3 Press ENTER.
To enter fractions
1 Click a cell.
2 Type a number as a decimal.
3 Press ENTER.
4 Click the cell.
5 Click Format } Selection properties.
6 Click the Numeric format tab.
7 Choose Fraction from the Numeric formats list.
8 Choose a type from the Fraction list.
2 Type a number as a decimal.
3 Press ENTER.
4 Click the cell.
5 Click Format } Selection properties.
6 Click the Numeric format tab.
7 Choose Fraction from the Numeric formats list.
8 Choose a type from the Fraction list.
To enter a date or time
1 Click a cell.
2 Type a date or time.
3 Press ENTER.
2 Type a date or time.
3 Press ENTER.
To enter the current date
1 Click a cell.
2 Click Insert } Date.
2 Click Insert } Date.
Quattro Pro inserts the short date format specified in Windows’ Regional Settings on the
Control Panel.
You can also enter the current date by clicking a cell and pressing CTRL + D.
Creating a spreadsheet
185