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
•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.
91