When numbers are formatted as text, they cannot be used in calculations or
If you have already entered normal numbers in cells and have afterwards changed
the format of the cells to "Text", the numbers will remain normal numbers. They
will not be converted. Only numbers entered afterwards, or numbers which are
then edited, will become text numbers.
If you decide to enter a number directly as text, enter an apostrophe (') first. For
example, for years in column headings, you can enter '1999, '2000 and '2001. The
apostrophe is not visible in the cell, it only indicates that the entry is to be recog-
nized as a text. This is useful if, for example, you enter a telephone number or
postal code that begins with a zero (0), because a zero (0) at the start of a sequence
of digits is removed in normal number formats.
You can display one and the same figure in various ways, but internally it always
remains the same number.
For example, enter the number 12345.6789. The number is displayed with only two
decimal places in the sheet, that is, 12345.68. However, all four decimal places are
still remembered by the program.
You can select other display options by choosing Format - Cells. All the defined
formats are lists on the Numbers tab. A preview shows you how the result will
look. In this dialog you can define your own formats, that you can then apply to
numbers or other content of your spreadsheets.
There are various ways to enter integers starting with a zero:
Enter the number as text. The easiest way is to enter the number starting with
an apostrophe (for example, '0987). The apostrophe will not appear in the cell,
and the number will be formatted as text. Because it is in text format, however,
you cannot calculate with this number.
Format a cell with a number format such as \0000. This format can be assigned
in the Format code field under the Format - Cells - Numbers tab, and defines
the cell display as "always put a zero first and then the integer, having at least
three places, and filled with zeros at the left if less than three digits".
196 StarOffice™ 7 User's Guide