Defining the Decimals Element of a Custom Number Format
The Decimals element lets you customize the appearance of decimal digits in a table
cell. Decimal digits are numbers that appear to the right of a decimal point.
After adding a Decimals element to a custom number format, you select it, click its
disclosure triangle, and then use the options in its pop-up menu to customize the
element’s display attributes.
See “Creating a Custom Number Format” on page 102 to learn how to add a
Decimals element.
Here are ways to use the Decimal element’s pop-up menu:
To display decimal digits as numbers, choose Decimals.
m
To represent unused decimal digits when their number is fewer than a particular
number of digits, choose Show Trailing Zeros or “Use Spaces for Trailing Zeros.” Then
increase or decrease the number of zeros or hyphens displayed in the format field;
choose Add Digit, Remove Digit, or “Number of Digits” from the pop-up menu, or use
the Up Arrow or Down Arrow key to set the number of digits.
If more decimal digits than the number you specify are entered into a table cell,
they’re rounded to match your number of digits.
To display decimal digits as a fraction, choose Fractions.
m
To specify a fractional unit (for example, Quarters), click the element’s disclosure
triangle again and choose an option from the pop-up menu.
To avoid displaying decimal digits when they’re entered into a table cell, don’t add the
m
Decimals element to the format field.
Displayed values are rounded to the nearest integer when decimal values are
entered into a cell.
When you choose
This number
Is displayed like this
Decimals and Show Trailing
Zeros and set “Number of Digits”
to 6
100.975
100.975000
Fractions and select the “Up to
two digits (23/24)” option
100.975
100 39/40
A space is displayed between
the integer and the fraction
when you add a Spaces element
between Integers and Decimals
elements in the format field.
Fractions and select the
Quarters option
100.16
100 1/4