Help with formula
Format/ Cells/ Number/ Fraction, and choose an appropriate option.
If you want a formula to give you a text output, try =TEXT(A2,"# ?/?")
Also, for better accuracy in your existing formula, instead of =c/3.14 use
=c/PI()
--
David Biddulph
"Jack Deuce" wrote in message
...
I'd like to be able to convert decimal to fraction of an inch. IOW I
have calculated, from the circumference, the diameter (d=c/3.14) and
would like to show the actual inches instead of the decimal
equivalent. 6.250 decimal would display 6 1/4, 6.375 decimal would
display 6 3/8.
Thanks in advance
|