Creating a Custom Number Format
To define your own display format for numbers in table cells:
Select one or more cells.
Choose Custom from the Cell Format pop-up menu in the Format pane of the
Drag the elements to
the format field.
From the Type pop-up menu, choose Number & Text.
Define your number format by dragging the (blue) elements from the Number & Text
Elements box into the format field above the box.
When an element is in the format field, click its disclosure triangle and choose a
formatting option from the pop-up menu.
Click a disclosure triangle to
choose a formatting option.
Integers: Add this element when you want to format digits to the left of a decimal
point. See “Defining the Integers Element of a Custom Number Format” on page 209
for more information.
Currency: Add this element to display a currency symbol. To identify the symbol you
want to use, click the Currency element’s triangle and choose a symbol.
Working with Table Cells
Working with Table Cells
Decimals: Add this element to format how decimal digits are displayed. See “Defining
the Decimals Element of a Custom Number Format” on page 210 for more information.
Spaces: Use this element to control the amount of space displayed between elements.
Click the Spaces element’s triangle and choose an option. Normal adds a standard
space, Wide adds an em space, and Narrow adds a sixth of an em space. You can add
more than one Spaces element to the format field with these options, but only one of
the Spaces elements can be Flexible. Flexible left-aligns elements that precede it and
right-aligns elements that follow it.
Scale: Use this element to size the display value of a number. For example, you can
display values over 100 as number of hundreds (1000 displays as 10). See “Defining the
Scale of a Custom Number Format” on page 212 for more information.
To display predefined text before or after any element, place an insertion point in the
format field, and then type your text. You can click any element and use the Left Arrow
and Right Arrow keys to place the insertion point.
To delete an element in the field, select it, and then press Delete.
To move the element around in the field, drag it.
In the Name field, type a name for your number format.
Custom format names are listed in the Cell Formats pop-up menu in the Format pane
of the Table inspector.
Click OK to save your number format and apply it to the selected cells.
Here’s an example of a number format:
The hyphen is a Spaces element, set to display one Normal space between the
currency symbol and the number.
The dollar sign is a Currency element.
#,### is an Integers element that displays numbers greater than 999 with a
.## is a Decimals element.
When you type this number into a cell with the
The number is displayed like this
Balance: $ 10,000.000
Balance: $ 0.95
Balance: $ 0.67