In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4
 

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?

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?

In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4
 

"Terry Kappler" wrote:

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?

Actually I am entering formulas with the results displayed as fractions. I
was able to round to 16ths and format the cells in ##/## and it worked fine.
Thanks for the response.