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.

View in gallery

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.

View in gallery

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.

View in gallery

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.

View in gallery

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

View in gallery

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?