Converting Decimal Fractions to Fractions of a Specified Number

 

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:

image 1

 

Press Enter key:

image 2

 

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

image 3

 

  • Press Enter

image 4

 

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.

Follow below given steps:

  • 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

image 5

 

image 6

 

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.

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com



Example:


Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>