Microsoft Office Tutorials and References
In Depth Information
Working with Fractions
the Category list, click Custom and then enter a number format string in the Type field. For
example, enter the following Number format string in the Type field to display a value in 32nds:
Figure 36-2: Displaying values as fractions.
The following number 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 16ths, with a quotation mark appended to the right.
This format string is useful when you deal with inches (for example, 2 ⁄ 16 ”).