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, are listed in the Cell Formats
pop-up menu in the format bar.
Custom formats are also listed in the Cell Format pop-up menu in the Cells inspector.
To learn how to
Go to
Define 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 102
“Defining the Integers Element of a Custom
Number Format” on page 104
“Defining the Decimals Element of a Custom
Number Format” on page 105
“Defining the Scale of a Custom Number
Format” on page 106
Define custom number formatting that varies
with the value of a number in a table cell
“Associating Conditions with a Custom Number
Format” on page 108
Define a custom date/time format, which
specifies 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 110
Define text you want to appear next to a value
entered into a table cell
“Creating a Custom Text Format” on page 111
Manage the custom formats you create
“Changing a Custom Cell Format” on page 112
“Reordering, Renaming, and Deleting Custom Cell
Formats” on page 113