2
Table Of Contents
- User’s Guide
- Contents
- Welcome to Pages
- Overview of Pages
- Creating a Document Using the Pages Templates
- Formatting a Document’s Layout and Table of Contents
- Setting Page Orientation and Size
- Setting Page Margins
- Creating Columns
- Varying Column and Page Layouts
- Creating a Document With Left- and Right-Facing Pages
- Adding Headers, Footers, Page Numbers, Footnotes, and Endnotes
- Varying Document Formatting Using Section Breaks
- Adding a Repeated Background Image
- Using a Table of Contents
- Formatting Text and Paragraphs
- Working With Styles
- Working With Graphics andOther Media
- Changing Object Properties
- Creating Tables
- Adding a Table
- Using Table Cells and Borders
- Formatting Tables
- Adding Images or Background Colors
- Formatting Numbers
- Sorting Cells
- Autofilling
- Using Formulas
- A Tour of Using Formulas
- Adding a Quick Formula
- Removing a Formula
- Using the Formula Editor to Add and Edit Formulas
- Using Cell References
- Adding a Formula to Multiple Cells
- Performing Arithmetic Operations
- Using Predefined Functions
- Operators and Functions for Advanced Table Formula Users
- Defining Formulas That Use Operators
- Defining Formulas That Use Functions
- Creating Charts
- Personalizing Documents With Address Book Data
- Printing and Exporting Your Document to Other Formats
- Designing Your Own Document Templates
- Index
Chapter 8 Creating Tables 179
If you use the % suffix, data in the cell is displayed followed by the % symbol. If the
data in the cell is used in a formula, it’s converted into a decimal number. For example,
3% becomes 0.03. See “Using Formulas” on page 183 for details.
After you define a number format, you can associate the format with multiple cells by
using autofilling. See “Autofilling” on page 182 for instructions.
Applying Number Formats
To add a value to an empty cell that has a number format:
m Select the cell and type a number. The number format is applied when you press
Enter or click outside the cell.
To apply a number format to an existing value:
1 Select one or more cells that contain numbers.
2 Open the Table Inspector. Click Inspector in the toolbar (or choose View > Show
Inspector), and then click the Table Inspector button.
3 Click the Numbers button.
Select to define a display
format for numbers in
selected cells.
Choose or type a symbol to
precede numbers.
Select whether to use a
thousands separator.
Choose or type a symbol
to follow numbers.
Set the number of
decimal places to display.
Select a style for displaying
negative numbers.