Chapter 9 Working with Table Cells 207
3 Choose Scientic from the Cell Format pop-up menu.
4 Use the Decimals eld to specify the number of decimal places to display.
Using the Text Format in Table Cells
Use the text format when you want all of a cell’s content to be treated as text, even
when it’s a number. When a text format is applied to a cell, its value is displayed exactly
as you type it.
To dene a text format for one or more selected cells:
1 Select the cell or cells.
2 Click Inspector in the toolbar, click the Table inspector button, and then click Format.
3 Choose Text from the Cell Format pop-up menu.
Using Your Own Formats for Displaying Values in Table Cells
You can create your own cell formats for displaying numbers, text, and date and time
values. Cell formats you create, called custom formats. Custom formats are also listed in
the Cell Format pop-up menu in the Table inspector’s Format pane.
To learn how to Go to
Dene a custom number format that applies
currency, decimal digit, and other display
formatting to a number in a table cell
“Creating a Custom Number Format” on page 207
“Dening the Integers Element of a Custom
Number Format” on page 209
“Dening the Decimals Element of a Custom
Number Format” on page 210
“Dening the Scale of a Custom Number
Format” on page 212
Dene custom number formatting that varies
with the value of a number in a table cell
“Associating Conditions with a Custom Number
Format” on page 214
Dene a custom date/time format, which species
day, month, year, hour, minute, and other aspects
of a date/time value in a table cell
“Creating a Custom Date/Time Format” on
page 216
Dene text you want to appear next to a value
entered into a table cell
“Creating a Custom Text Format” on page 217
Manage the custom formats you create “Changing a Custom Cell Format” on page 218
“Reordering, Renaming, and Deleting Custom Cell
Formats” on page 220
Creating a Custom Number Format
To dene your own display format for numbers in table cells:
1 Select one or more cells.
Comments to this Manuals