number format needed in inches

[Jon Emberton]

I need to have a colum calculate in a standard inch measurment
1/16-15/16, which I found that in the number category, but I need it to
be reduced to its simplest form ie. I need it to disply 1/2 instead of
8/16. anyone know how to do this?

Thanks

 

[Jerry W. Lewis]

Instead of formatting as sixteenths,
=ROUND(x*16,0)/16
and format as a 2-figure fraction.

Jerry