View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4

By default, XL does display the LCD.

How are you entering your fractions?

Try:
0<space8/16
And see what you get.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Terry Kappler" <Terry wrote in message
...
I have a large spreadsheet in which I wish to display fractional values up
to
16ths. I want the fractions to round down to the lowest denominator. For
instance 8/16 should display as 1/2 and 10/16 should display as 5/8. The
spreadsheet is too large to go through and individually change the format
cell by cell. Can anyone help?