Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
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 ??
Re: improper fractions
Posted by giacomo on December 06, 2001 6:28 AM
Use the following custom format: ?/?
Re: improper fractions
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.
Re: improper fractions
Posted by David Manning on March 17, 2002 1:55 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.