Entering values
A value is a number, formula, date, or time. Quattro Pro determines that data is a value from the characters you type. The data type displays in the application bar.
For information on entering formulas see “Working with formulas and functions.”
Numbers entered in cells can consist only of the following:
|
•
|
|
numerals (0 to 9)
|
|
•
|
|
minus sign (-) for negative numbers
|
|
•
|
|
plus sign (+) for positive numbers
|
|
•
|
|
currency symbols; for example, $
|
|
•
|
|
one decimal point
|
|
•
|
|
a trailing %
|
|
•
|
|
an E for scientific notation
|
When entering numbers, be aware of the following restrictions:
|
•
|
|
Use a minus sign (-), not parentheses, to indicate a negative number. However, if you change the numeric format to currency or a value with a decimal, negative numbers appear in parentheses.
|
|
•
|
|
Do not include spaces in the entry.
|
|
•
|
|
If a number does not fit into a cell, it is displayed in exponential format.
|
|
•
|
|
Use numeric characters, not letters, to represent 1 and 0. For example, do not substitute a lowercase l (“el”) for 1 (one) or an uppercase O (“oh”) for 0 (zero).
|
|
•
|
|
Quattro Pro also lets you enter numbers as fractions.
|
You can enter fractions in a cell.
You can enter a date or time, including the current date, in a cell. While Quattro Pro reads dates and times as values, it applies specific formatting and calculation criteria to them depending on the date and time 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. For information on entering dates prior to 1900 and after 2000, see “Entering dates.”
You can also automatically enter the current date.
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 example, 2.5 represents January 1, 1900 at 12:00 noon.
If a notebook includes many dates, you may want to force specific cells to accept only dates and times. This is particularly useful when you create notebooks that others will use.
For information about restricting cell data, see “Restricting and annotating cell data.”
To enter a number |  |
|
1.
|
|
Click a cell.
|
|
2.
|
|
Type a number.
|
|
3.
|
|
Press Enter.
|
|
•
|
|
You can change the number of decimal places in a value. For more information, see “To change the number of decimal places in a value.”
|
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.
|
To enter a date or time | |
|
1.
|
|
Click a cell.
|
|
2.
|
|
Type a date or time.
|
|
3.
|
|
Press Enter.
|
|
•
|
|
For a list of available date and time formats, see “Default date and time formats.”
|
To enter the current date | |
|
1.
|
|
Click a cell.
|
|
2.
|
|
Click Insert
Date. |
|
Quattro Pro inserts the short date format specified in the Windows Regional Settings on the Control Panel.
|
|
•
|
|
You can also enter the current date by clicking a cell and pressing Ctrl + D.
|
To enter a date by using the spreadsheet DATE function | |
|
1.
|
|
Click a cell.
|
|
2.
|
|
Click Insert
Insert function. |
|
3.
|
|
Choose Date from the Function category list.
|
|
4.
|
|
Choose DATE from the Function list.
|
|
5.
|
|
Click OK.
|
|
6.
|
|
Type the date (year, month, and day) between parentheses.
|
|
7.
|
|
Press Enter.
|
|
•
|
|
For a list of available date and time formats, see “Default date and time formats.”
|