try putting =MROUND(51.333,0.125) and then formatting it to upto 1 digit (the
1/4 format).
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"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