number format needed in inches

  • Thread starter Thread starter Jon Emberton
  • Start date Start date
J

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
 
Instead of formatting as sixteenths,
=ROUND(x*16,0)/16
and format as a 2-figure fraction.

Jerry
 
Back
Top