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

T

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?
 
R

RagDyer

By default, XL does display the LCD.

How are you entering your fractions?

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

Terry Kappler

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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top