Table of Contents
Advertisement
Notes on Entering Labels
If you enter
a label
wider
than the cell, it spills over into the next cell to the
right as long as that cell is empty.
If the cell to the right is full, the text
appears
cut off. The complete
text of the label
is stored
in the cell, but you
cannot
see it unless
you make
the column
wider
(see Changing
the
Appearance
of a Spreadsheet
on page
82).
To enter
a number
as a label or to enter
a label that begins
with an equal
sign
(=), start by typing
an apostrophe
() or a double
quotation
mark
('). When
you start an entry
with a double
quotation
mark,
the entry
appears
left
justified
and the double
quotation
mark
does not appear.
For example,
to
enter
1993
as a label,
type "1993.
To enter =National
Average
as a label,
type "=National
Average.
Notes on Entering
Values
1The Lat._Ml_mae Ldk:Jlontt °
If a cell is not wide enough
for a numeric
value you enter (or for the result of
a formula), the symbol ### appears
in the cell, as shown in the illustration to
the left. The value is stored in the cell, but you cannot see it unless you make
the column wider. (See Changing the Appearance
of a Spreadsheet
on page
82.)
You can enter
values
between
lOqS, z and 10_s,2. All numbers
and calculations
are accurate
to 15 decimal
places.
Even when
Spreadsheet
rounds off a
number-to
few er-tharr
I5_ecimal
places,
it uses all 15 decimal
places'in
calculations.
Do not enter
commas
or dollar
signs
when
you enter values,
although
you
can specify
a format
that adds commas
automatically.
(See Changing
the
Number
Format
for Values on page
74.)
You can use any of the following characters
in the values you enter:
1234567890+-Ee.
Use E or e to specify
scientific
notatiofi.
For example,
to enter 3.75 x 10 zs, you
can type either
of the following:
3.75e15
or 3.75E15.
Spreadsheet
73
Advertisement
Table of Contents
