MrExcel Publishing
Your One Stop for Excel Tips & Solutions

improper fractions


Posted by barry ross on December 06, 2001 6:22 AM

i am trying to show fractions in the improper form, e.g. as british betting odds.

if i enter,say, 11/8 this then shows as 1 3/8.

i just want it to show up as 11/8

can anyone help ??


Posted by giacomo on December 06, 2001 6:28 AM

Use the following custom format: ?/?

Posted by Ren on December 06, 2001 6:42 AM

You can format the cell as text and it will show up as typed or in cell format choose custom
number and type "##/##" that will kep it as a number and allow you to have improper fractions.

Posted by David Manning on March 17, 2002 1:55 PM