You can enter numbers (including dates and times), text, or formulas into spreadsheet cells. You can enter up to 255 characters in a cell.
|
|
|
|
|
|
|
This type of data |
|
Consists of |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Numeric |
|
The numbers 0 through 9. To enter a negative number, type a minus sign (hyphen) before the number. AppleWorks displays and stores a maximum of 11 significant digits. You can sort numeric data and use it to perform calculations or produce charts. |
|
|
|
|
|
|
Tip: To enter numbers with leading zeros, type an equal sign (=) and quotes around the number, for example, ="001". |
|
|
|
|
Date and time |
|
Dates and times entered as numbers (for example, 8/12/00, 17:20, or 5:20 PM). You can sort dates and times and use them to perform calculations or produce charts. |
|
|
|
|
Text |
|
All letters, numbers, and symbols. |
|
|
|
|
|
If you enter letters or symbols with numbers into a cell, AppleWorks treats the cell contents as text. |
|
|
|
|
Formula |
|
A set of instructions for calculating a value in a spreadsheet cell. You enter the formula in the entry bar, and the result appears in the spreadsheet cell. |
|
|
|