that is an option. i would like for it to read a little differently. maybe
I should ask this question in a different way: I would like the end result to
read no smaller than 1/8th increments, and if it needs to be reduced to the
LCD, some formula or formatting is performed automatically. for instance, if
i have a value of 51.3333, this value rounds to the nearest 1/8th increment
of 51 3/8; however, if I use this custom formatting of # 0/0, then that gives
me 51 1/3 (which is indeed correct). all i want to do is reduce frations if
they are not already in the lowest common denominator. for example, 14.5
shown as 14 1/2, not as 14 4/8 and leave 51.3333 as 51 3/8. thanks and i
appreciate any additional help you can provide.

"pinmaster" wrote:

Hi,

Have you tried a custom format: # 0/0

HTH
Jean-Guy

"Chad" wrote:

I've got a formula that I want to read in a fraction (i.e. 14 1/2 instead of
14.5). I've formatted the cells to read as a fraction in 1/8 increments.
The problem is I sometimes get things like 14 4/8, instead of the LCD and
being reduced to 14 1/2. Any suggestions on how to get around this and
display the lowest common denominator? Thanks.

-Chad