Set the fractional type number format in Excel2010

In the EXCEL2010 worksheet, the user can set a fraction of the decimal in the selected cell to indicate that the Excel2010 fractional format rounds the decimal number to the nearest score. In the score category, the user can select fractions of 2, 4, 8, 16, 10, and 100, and can set the number of digits for the denominator (including 1-bit denominator, 2-bit denominator, and 3-bit denominator).

To set the fractional type number format in the EXCEL2010 worksheet, the following steps are described:

Tools/raw Materials

Excel2010

Steps/Methods

Step 1th, open the Excel2010 workbook window and select the cells that you want to set the fractional type number format for. Right-click the selected cell and select Format Cells on the open shortcut menu, as described in Figure 2010081103.

Figure 2010081103 Selecting the Format Cells command

Step 2nd, in the Open Excel2010 Format Cell dialog box, switch to the Number tab and select the Score option in the Category list. Then select the fraction type in the score type list. For example, the decimal 0.56789 is set to a fraction, select the denominator as a decimal value of 4/7, select the denominator two decimal value to 46/81, and select the denominator three decimal value as the same as 46/81, which is related to the result of the calculation; Select 2 as the denominator value of 1/2; With 4 as the denominator value of 2/4, select 8 as the denominator value of 5/8, select 16 as the denominator value of 9/16, select the value with 10 as the denominator as 6/10, and select 100 as the denominator to 57/100. The user can select the appropriate score type according to the actual needs and click the OK button as shown in Figure 2010081104.

Figure 2010081104 Setting the fractional format in Excel2010