Types of spreadsheet data

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.

Related topics

  Entering and editing spreadsheet data
Sorting spreadsheet data
About charts
About functions

 
Table of contents Index