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
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 207
“Defining the Integers Element of a Custom 
Number Format” on page 209
“Defining the Decimals Element of a Custom 
Number Format” on page 210
“Defining the Scale of a Custom Number 
Format” on page 212
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 214
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 216
Define 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