How to Format Fractions in Google Sheets

There are different types of fractions in math such as improper fractions and mix fractions. Improper fractions are fractions that nominators are greater than denominators, while the mixed fraction is the combination of the integer and fraction.

1. Proper and Improper Fractions

Step 1: Select the numbers in Google sheets that you want to format into fractions;

Step 2: Click the "Format" tab from the ribbon, and click the "Number" command from the drop-down list;

Step 3: In the extended list, click "More formats" at the bottom and then "Custom number format";

Step 4: To format the numbers into proper or improper fractions;

1. Click or type "?/?" in the custom number box to have the denominator one digit;

2. Click or type "??/??" in the custom number box to have the denominator up to two digits;

3. Click or type "???/???" in the custom number box to have the denominator up to three digits.

Step 5: You can use fixed numbers as denominators, for example, 10 for two digits and 100 for 3 digits;

1. Type "?/5" in the custom number box to have 5 as the denominator;

2. Type "??/10" in the custom number box to have 10 as the denominator;

3. Type "???/100" in the custom number box to have 100 as the denominator.

2. Mixed Fractions

Step 6: To format numbers into mixed fractions, you need to type the "#" sign in front of "?/?", "??/??", "???/???" in the custom number box;

1. Type "# ?/?" in the custom number box to have the mixed fraction with one digit denominator;

2. Type "# ??/??" in the custom number box to have the mixed fraction with two digits denominator;

3. Type "# ???/???" in the custom number box to have the mixed fraction with three digits denominator.

Step 7: You can format numbers into mixed fractions with fixed numbers as denominators.

1. Type "# ?/5" in the custom number box to have mixed fraction with 5 as the denominator;

2. Type "# ??/10" in the custom number box to have mixed fraction with 10 as the denominator;

3. Type "# ???/100" in the custom number box to have mixed fraction with 100 as the denominator.

Leave a Reply