I looked at that..., but if it amounts to 1/4", we want it to show 1/4", not
4/16", that will slow down the process doing the conversion in the shop. I
know, picky, picky. :-)

John

"akphidelt" wrote:

Wouldn't the formatting to sixteenths work?

If you go to Format--Cells--Number--Fraction

Then click on As Sixteenths?

Or does that not meet your criteria?

"John G." wrote:

I have cells formatted as fraction, up two digits. We are a mfg. company
cutting metal and if it is not on a tape measure, we don't use it. If we
input in an odd decimal value, we can get stuff like 17/20 or other wierd
unusable fractions. Is there a way to have the same cell of input to show a
result rounded up to the absolute nearest 1/16th of an inch?