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

[Terry Kappler]

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?

 

[RagDyer]

By default, XL does display the LCD.

How are you entering your fractions?

Try:
0<space>8/16
And see what you get.

 

[Terry Kappler]

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.