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:
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:
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
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
