Fractions Number format

[Lee Harris]

Is it possible to do a custom number format for cells such that fractions
are displayed. I'm guessing not because there'd be a limit on what fractions
you could display, but I would probably only be interested in showing a half
as the little 1/2 (alt,0189 I think) rather than .5

 

[Gord Dibben]

Lee

There are a limited number of fractions that can be shown under
Format>Cells>Fractions.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[Andre Croteau]

Hi Lee,

You can enter directly in the cell, For example, type in 1 3/4 (with
space in between yhe interger and fraction

André

 

[Leo Heuser]

Lee

Try this custom number format

# ?/?

The little 1/2 is a special character, as you point
out yourself, and it's inserted as text and cannot be
used in calculations.


--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only, please.