• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Format Fractions in Excel

July 29, 2021 by Andrew Childress
Fractions in Excel

When you’re working in a spreadsheet, you may find yourself working with fraction values. Let’s learn how to format fractions in Excel.

When you’re working in a spreadsheet, you may find yourself working with fraction values. By default, Excel may convert fractions into alternate formats. For example, typing 1/2 will convert to 2-Jan. But fortunately for you, it’s easy to display fractions by making a few quick adjustments. Let’s learn how to format fractions in Microsoft Excel.

How to Format Fractions in Excel

As mentioned, Excel may format fractions incorrectly based on how you input them. The key here is to specify the correct cell formatting prior to typing in the values. In this way, you’re sure to see fractions display just how you want.

To get started, click into a cell where you wish to place a fraction. Then, right-click inside the cell. From the dropdown menu that appears, choose Format Cells.

Fractions in Excel

Excel will open the Format Cells menu. Here, you can make a variety of choices about how content appears in the selected cell. For this example, click Fraction in the Category sidebar on the Number tab.

Here, you can select the type of fraction to display. You’ll see choices for Up to One Digit, Up to Two Digits, and so on. For a simple fraction like 1/2, you can choose Up to One Digit (1/4). Click on the format, then choose OK.

Format fractions in Excel

Now, you can type 1/2 into the cell, and Excel will preserve the fraction formatting. Notice that in the Formula bar, Excel recognizes the value as 0.5. This means that you can use the fraction cell in formulas to correctly perform math calculations.

How to format fractions in Excel

As you can see, Microsoft Excel makes it easy to type in and work with fractions. It only takes a few quick steps to set up your cell formats prior to typing in your fractions. This is a great way to display numbers in fraction format, with no hard work required.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Merge cell styles in ExcelHow to Merge Cell Styles in Excel
Next Post:How to Show the Bottom Percents Of Your Data in ExcelShow bottom percents of your data in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top