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

[SouthAfricanStan]

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?

 

[T. Valko]

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.

 

[Bob Phillips]

set the cell to a custom format of

# ##/##

--
HTH

Bob

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

 

[Gord Dibben]

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

 

[ilia]

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.

 

[MMullett\(BTInternet\)]

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