Dealing With Fractions In Excel 2010

Excel provides list of functions, features, tools and formatting styles which brings down the complexity of huge spreadsheets. Dealing with Fractions in Excel has been a problem because it always converts them in a different form. In this post we will guide you through the simple way to work with fractions in Excel spreadsheets.

To start off with, launch Excel 2010 spreadsheet in which you want to use fractions. For instance we have included a spreadsheet containing S.No, Values1 and Values2, in which we will be entering fraction values. By default Excel changes the value written in fraction form into calendar(month/year) value, as you can see in the screenshot below.


To get over with it, select the fields in which you want to show fractions and navigate to Home tab and click small button in Number group, as shown in the screenshot below.

home tab

From left sidebar of the Format Cells dialog, select Fraction and from right pane under Type, choose the fraction type according to your needs. Click OK to continue.


Now start filling out your datasheet. For writing compound value, write the number followed by space and then fraction value. Excel has a built-in ability to simplify the fraction as you write in real-time, for e.g, 21/6 will be changed into 7/2.


Now you can perform all the simple arithmetic and complex operations easily.


You can also check out our previously reviewed Excel functions; LARGE, CEILING, RANK, TIME, ADDRESS ,FACT (factorial), MAX,MIN, MAXA, MINA and EXACT, Logical Functions, INFO, SUMSQ, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, & LEN.

  • Guest

    how does one turn off the automatic simplification of fractions?