55
• If you enter data that looks like a date into
a General cell, PenCell interprets the data
as a formula first. If it fails, it tries to
interpret the data as a date. For instance,
12/28/96 in a General cell is interpreted
as 12 divided by 28 divided by '96.
However, 28-Dec-96 is interpreted as a
date. Once you enter a date in a General
cell, its type changes to a Date/Time
format.
• If you enter True or False in a General
cell, PenCell interprets these as logical
values 1 and 0 and can use them in
logical and relational functions.
Label Limits cell contents to labels. If you enter
any data in a Label cell, PenCell uses the
data as a label.
Logical Displays cell contents as logical true (non-
zero) or false (0). Logical results are
computed from logical and relational
operations in formulas or can be entered
directly. See Appendix B, “
Function Refer-
ence
.”
Cell Type Description
Date/Time Displays cell content in one of the selected
date/time format. Date/time formats are:
Format Example
DD-MMM-YY 28-Dec-96
DD-MMM 28-Dec
MMM-YY Dec-96
HH:MM:SS (AM/PM) 02:34:51 AM
HH:MM (AM/PM) 02:34 AM
MM/DD/YY 12/28/96
MM/DD 12/28
HH:MM:SS 02:34:51 (24 hour)
HH:MM 02:34 (24 hour)
General By default, all cells have the General format
until you change them.
• General cells can contain a value,
formula, or label.
• If you enter a number in a General cell, it
is right justified.
• If you enter text in a General cell, it is
interpreted as a label and is left justified.
• If you enter a formula (including a cell
reference) in a General cell, the com-
puted result of the formula is displayed. If
the result is a number, it is right justified
and if it is text, it is left justified.
To Next Page
Loading...
