David,
This works great, but the results in the cell show a outlined square between
my round number and my fraction. Not displaying a space properly. Wierd. But
thanks for the code. Now to do something about the space being displayed by a
square. I tried to paste it here but it did not show.

"David Biddulph" wrote:

Well, if you do want to be picky, try
=IF(MOD(CEILING(A1,1/16),1)=0.5,TEXT(CEILING(A1,1/16),"#
?/2"),IF(MOD(CEILING(A1,1/16),0.5)=0.25,TEXT(CEILING(A1,1/16),"#
?/4"),IF(MOD(CEILING(A1,1/16),0.25)=0.125,TEXT(CEILING(A1,1/16),"#
?/8"),TEXT(CEILING(A1,1/16),"# ?/16"))))
--
David Biddulph

"John G." wrote in message
...
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?