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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 said:
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?
Click to expand...

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.
 
Back
Top