Apple numbers User Manual

 Using Tables

 

m

After you define a cell format, you can associate the format with multiple cells by using 
autofilling. See “Autofilling Table Cells” on page 68 for instructions.

Use the number format to format the display of a number’s decimal places, thousands 
separator, and negative values. 

To define a number format that displays two decimal places, no thousands separator, 
and negative numbers with the negative symbol, select one or more cells and then 
click the Number Format button in the Format Bar. Use the Decrease Decimal Places 
and Increase Decimal Places buttons located nearby to change the number of decimal 
places.

For more control over the number format, use the Cells Inspector.

Select the cell or cells. 

Click Inspector in the toolbar, and then click the Cells Inspector button.

Choose Number from the Cell Format pop-up menu.

To specify how many decimal places to display, use the Decimals field. If a value 
contains more decimal places than you specify, the decimal value displayed is rounded, 
not truncated. For example, if a cell is formatted to display two decimal places, the 
value 3.456 is displayed as 3.46, not 3.45.

To specify how to display negative values, choose an entry from the pop-up menu 
adjacent to the Decimals field.

To specify whether to use a thousands separator, select Thousands Separator.

Number Format 
button

Increase Decimal 
Places button

Decrease Decimal 
Places button