Problem with Fraction format in Excel

Asked By jomar05 0 points N/A Posted on - 08/08/2011

Good day!

While it is true that we can use the Fraction format in the Number group (Home) to enter fractions as fractions and not date

(such as 1/5 and not 5-Jan, etc.).

How can we prevent Excel from automatically rounding off to 1/2 for fractions that are actually equal to 1/2 but we want it displayed the way we key-in the fraction (e.g. 3/6, 4/8, 5/10, etc).

Thanks a lot

JOMAR

• Status: Open
• Question Views: 1055
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Pauloo

Go To Solution

Best Answer

Best Answer

Answered By Pauloo 0 points N/A #97616

Problem with Fraction format in Excel

Fraction formatting in Excel could be very tricky especially when you are no used to solving problems that involves calculation with Microsoft Excel.

So, anytime you are having problem with fraction formatting, you can follow the steps as narrated below:

• Open an Excel blank  worksheet and highlight the areas that you want formatted in fractions by clicking the cells with your mouse.
• Select fraction from the displayed menu. You will observe that any data within the highlighted areas will be in fraction format.
• Position you cursor in the highlighted area and right click the mouse and you will see rows of menus.

Thanks.

About Pauloo

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/08/2011
• Question Category: MS Excel

Answered By zicooo82 0 points N/A #97617

Problem with Fraction format in Excel

The first method:

• Suppose that the cell that you want to add fraction on it is A1.
• Format the cell as text.
• If you want to treat with the cell as calculation you have to use the following formula:

      =VALUE(LEFT(A1,FIND("/",A1)-1))/VALUE(MID(A1,FIND("/",A1)+1,LEN(A1)))

The second method:

• If you know the denominator number you can easily get the custom format and change it like the following:

     # ???/X

Note: X  > refer to the denominator.

About zicooo82

Questions
0

Answers
11

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/18/2011
• Question Category: MS Excel