Display Numbers As Fractions - Microsoft Support

Skip to main content Sign in with Microsoft Sign in or create an account. Hello, Select a different account. You have multiple accounts Choose the account you want to sign in with. Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

Use the Fraction format to display or type numbers as actual fractions, rather than decimals. You can perform calculations on these cells. However, if you're not calculating on the fractions, use text as an alternate display option. This will prevent autoformatting, but then you can't use them in calculations.

1. Select the cells that you want to format.

2. On the Home tab, click the Dialog Box Launcher next to Number.

   

3. In the Category list, click Fraction.

   

4. In the Type list, click the fraction format type that you want to use.

Fraction format	This format displays 123.456 as
Single-digit fraction	123 1/2, rounding to the nearest single-digit fraction value
Double-digit fraction	123 26/57, rounding to the nearest double-digit fraction value
Triple-digit fraction	123 57/125, rounding to the nearest triple-digit fraction value
Fraction as halves	123 1/2
Fraction as quarters	123 2/4
Fraction as eighths	123 4/8
Fraction as sixteenths	123 7/16
Fraction as tenths	123 5/10
Fraction as hundredths	123 46/100

The number in the active cell of the selection on the worksheet appears in the Sample box so that you can preview the number formatting options that you select.

Note: Be sure you've chosen the correct fraction type. If the exact fraction cannot be displayed, it will be rounded to the nearest result. Fractions will automatically be converted to the lowest denominator. To avoid this, in the Custom number section, enter # ?/16 (or whatever you want your denominator to be) in the Type box. This creates a fraction where the denominator is always fixed at 16.

Tips for displaying fractions

• After you apply a fraction format to a cell, decimal numbers as well as actual fractions that you type in that cell will be displayed as a fraction. For example, typing .5 or 1/2 results in 1/2 when the cell has been formatted with a fraction type of Up to one digit.

• If no fraction format is applied to a cell, and you type a fraction such as 1/2, it will be formatted as a date. To display it as a fraction, apply a Fraction format, and then retype the fraction.

• If you don't need to perform calculations on fractions, you can format a cell as text before you type a fraction into it by selecting Text as the format in the Category list. This way, the fractions that you type will not be reduced or converted to decimals. However, you cannot perform mathematical calculations on fractions that are displayed as text.

• To reset the number format, click General in the Category box (Format Cells dialog box) or in the Number Format box (Home tab, Number group). Cells that are formatted with the General format do not have a specific number format.

• If you enter a fraction and Excel thinks you want a date, enter a zero and a space before the fraction (e.g., 0 9/12). The zero will disappear after pressing Enter, and the cell will display the fraction.

• To insert special fraction characters like ½, ¼, ¾, select the cell and format as Text, then use Insert > Symbol (choose Latin-1 Supplement set). 

Need more help?

Want more options?

DiscoverCommunity

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Yes No Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.) What affected your experience? Resolved my issue Clear instructions Easy to follow No jargon Pictures helped Other Didn't match my screen Incorrect instructions Too technical Not enough information Not enough pictures Other Any additional feedback? (Optional) Submit feedback By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×