Microsoft Office Tutorials and References
In Depth Information
Displaying fractions
When you mix cells with Percentage and General formatting in a column, you might prefer to see
the nonpercent values indented from the right so that the values line up properly. To do so, apply
the following number format to nonpercent cells. This format string uses an underscore followed
by the percent symbol. The result is a space equal to the width of the percent symbol:
Displaying fractions
Excel supports quite a few built-in fraction number formats. (Select the Fraction category from
the Number tab of the Format Cells dialog box to see available formats.) For example, to display
the value .125 as a fraction with 8 as the denominator, select As Eighths ( 4 8 ) from the Type list.
You can use a custom format string to create other fraction formats. For example, the following
format string displays the fractional part of a value in 50ths:
# ??/50
The following format string displays a value in terms of fractional dollars. For example, the value
154.87 is displayed as 154 and 87/100 Dollars:
0 “and “??/100 “Dollars”
The following example displays the value in sixteenths, with a quotation mark appended to the
right. This format string is useful when you deal with inches (for example, 3 16 ").
# ??/16\”
Repeating text
The number format string displays the contents of the cell three times. For example, if the cell
contains the text Budget, the cell displays Budget Budget Budget:
;;;@ @ @
Search JabSto ::

Custom Search