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

 


Table of contents | Index