AppleWorks 6: Types of Spreadsheet Data

This article describes the 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.

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.
------------------------------------------------------------------------
This document contains information from Help Center, the help system included with your computer.

Published Date: Feb 20, 2012