
When you choose This number Is displayed like this
Decimals and Show Trailing
Zeros, and then set “Number
of Digits” to 6
100.975 100.975000
Fractions, and then choose “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 eld.
Fractions, and then choose
Quarters option
100.16 100 1/4
Dening the Scale of a Custom Number Format
The Scale element lets you display a number entered into a table cell using
percentage, scientic notation, or other value sizing conventions.
To use the Scale element:
1 Add it as “Creating a Custom Number Format” on page 207 describes.
2 Select it in the format eld, click its disclosure triangle, and then choose an option.
When you apply a format that includes a scale element to a cell that already contains
a value, the original value is preserved (it’s just displayed dierently). When you apply
the same format to an empty cell and then add a value to the cell, the actual value
takes into account the scale you’ve specied. The following table illustrates these cases.
212 Chapter 9 Working with Table Cells
Komentáře k této Příručce