In the Category list, at the left side of the dialog box, choose Fraction.The Number tab of the Format Cells dialog box. Excel displays the Format Cells dialog box. Click the Format tool in the Cells group, then click Format Cells.Select the cell (or cells) you want to format.You can specify a pre-defined fractional number format by following these steps: If you format a cell correctly, you can enter a number as 12.25 and have it displayed as 12 1/4. For instance, the building industry routinely uses fractions to measure lumber and distances. In some industries, fractions are the norm. Excel supports fractional number formats when displaying numbers in a cell.
0 Comments
Leave a Reply. |