91
Chapter 8 Pocket Sheet
Inputting Text
Text (letters and numbers) can be input into the active cell using the on-
screen text input keyboard.
•
Input make up entirely of numbers (including decimal point) is treated
as a numeric value. Inclusion of even a single non-numeric character
(alpha-character or symbol) causes the input to be treated as text.
•
Text is normally aligned in the cell flush left, while numbers are aligned
flush right.
•
If a text string is longer than the cell, the extra text is allowed to extend
into the next cell to the right in the sheet display, as long as the
neighboring cell does not contain any data. If it does, the extra characters
are cut off in the sheet display.
•
If an input value is longer than the cell that contains it, the contents of
the cell are replaced by a string of # marks. This is to let you know that
the cell contains a value, but the value cannot be displayed. If this
happens, try making the cell wider (page 97).
•
If the first character in a cell is an equals sign (=), the text is considered
to be part of a mathematical expression.
