Fractions Number format

  • Thread starter Thread starter Lee Harris
  • Start date Start date
L

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
 
Lee

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

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
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é
 
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.
 
Back
Top