"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.