I Need fractions other than 1/4, 1/2 & 3/4

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SouthAfricanStan - 09 Aug 2007 05:11 GMT

Win XP, Office 2003
Insert>Symbols - only 1/4, 1/2 & 3/4 are available.
How do I get other fractions, e.g. 1/3, 5/8 or 7/16 to appear?

Reply to this Message

T. Valko - 09 Aug 2007 05:46 GMT

You can format the cell to display fractions:

Format>Cells>Number tab>Fraction

Select one of the options available but it sounds like you want Up to two
digits.

Signature

Biff
Microsoft Excel MVP

> Win XP, Office 2003
> Insert>Symbols - only 1/4, 1/2 & 3/4 are available.
> How do I get other fractions, e.g. 1/3, 5/8 or 7/16 to appear?

Reply to this Message

Bob Phillips - 09 Aug 2007 08:50 GMT

set the cell to a custom format of

# ##/##

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Win XP, Office 2003
> Insert>Symbols - only 1/4, 1/2 & 3/4 are available.
> How do I get other fractions, e.g. 1/3, 5/8 or 7/16 to appear?

Reply to this Message

Gord Dibben - 09 Aug 2007 15:34 GMT

For symbols only, MS Reference2 and MS Reference Specialty fonts have quite a
few other than the 1/4, 1/2 and 3/4

Gord Dibben MS Excel MVP

>Win XP, Office 2003
>Insert>Symbols - only 1/4, 1/2 & 3/4 are available.
>How do I get other fractions, e.g. 1/3, 5/8 or 7/16 to appear?

Reply to this Message

ilia - 09 Aug 2007 16:37 GMT

I'm looking on character map, MS Mincho font unicode set. I'm seeing
1/3, 2/3, 1/5, 2/5, 3/5, 4/5, 1/6, 5/6, 1/8, 3/8, 5/8, and 7/8. 1/3
starts at 2153 (use Go to Unicode). I'm not seeing 16th divisions,
unfortunately.

> For symbols only, MS Reference2 and MS Reference Specialty fonts have quite a
> few other than the 1/4, 1/2 and 3/4
[quoted text clipped - 6 lines]
>
> - Show quoted text -

Reply to this Message

MMullett(BTInternet) - 28 Aug 2007 15:04 GMT

In a cell type 0 space 4/45 or whatever fraction you want.
Press enter.
Type 4 space 7/8, enter. You shoul see the pattern of the entries
Should do the trick
Mike

Reply to this Message