Dealing With Fractions In Excel 2010

Advertisement

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.

month

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.

Capture

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.

values

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

add

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.

Advertisement
  • Guest

    how does one turn off the automatic simplification of fractions?