Set fractional type number format in Excel2010

Source: Internet
Author: User

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:

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 1.

Figure 1 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 2.

Figure 2 Setting the fractional format in Excel2010

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.