Converting Decimal Fractions to Fractions of a Specified Number

http://www.exceltip.com/logical-formulas/converting-decimal-fractions-to-fractions-of-a-specified-number.html

In this article we will learn how to change the cell format into fraction. When we enter the value in fraction format Excel read that value as date and convert the number into date format.

Let’s take example and understand:

In cell A1 enter fraction 2/6, when we’ll type 2/6 then Excel will read it as date, and convert it into date format.

Enter 2/6:

Press Enter key:

Follow below given steps to enter the fraction value:

• Select the cell A1
• If you want to enter the fraction value 2/6 then enter 0 2/6

• Press Enter

Note: Excel always reduces a fraction to its smallest denominator. If you enter the fraction 2/6, Excel converts the fraction to 1/3. However, we can use the eights (4/8) type to fix the denominator to 8.

Sometimes we cannot find the right denominator, when we want to use 7/21,Excel converts it in smallest denominator. There is a way to show the same denominator which we want to show.

• Enter 7/21 in Cell A1
• Press Ctrl+1 on your keyboard
• Format cells dialog box will open
• In Number tab > Click on Custom > enter (# 7/21) to fix the value
• Click on OK

We can see in the above image fraction value has been fixed in the cell, also we can change the value with the other value as well and that would show as it is. So, to change the value you have to change it in custom formatting. In this way we can enter the fraction value.