You can create your own cell formats for displaying numbers, text, and date and time values. Cell formats that you create, called custom formats, are listed in the Cell Formats pop-up menu in the Format pane of the Table inspector.
Select one or more cells.
Click Inspector in the toolbar and click the Table button.
In the Table inspector, click Format.
Choose Custom from the Cell Format pop-up menu.
The custom format window opens.
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.
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.
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 thousands separator.
.## is a Decimals element.
When you type this number into a cell
|
The number is displayed like this
|
---|---|
10000000 |
Balance: $ 10,000.000 |
0.95 |
Balance: $ 0.95 |
.666 |
Balance: $ 0.67 |