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.

To define your own display format for numbers in table cells:
  1. Select one or more cells.

  2. Click Inspector in the toolbar and click the Table button.

  3. In the Table inspector, click Format.

  4. Choose Custom from the Cell Format pop-up menu.

    The custom format window opens.

  5. From the Type pop-up menu, choose Number & Text.

  6. Define your number format by dragging the (blue) elements from the Number & Text Elements box into the format field above the box.

    • 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 for more information.
    • Currency:  
      Add this element to display a currency symbol. To identify the symbol you want to use, add the Currency element and click its disclosure triangle and choose a symbol.
    • Decimals:  
      Add this element to format how decimal digits are displayed. See Defining the Decimals Element of a Custom Number Format for more information.
    • Spaces:  
      Use this element to control the amount of space displayed between elements. To specify the amount of space, add the Spaces element, click its disclosure triangle, and then 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; this option left-aligns the 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 for more information.
  7. 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.

  8. To delete an element in the field, select it and then press Delete.

    To move the element around in the field, drag it.

  9. 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.

  10. 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

Was this page helpful? Send feedback.