Help with formula
 

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

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

Help with formula
 

Right clickFormat CellsNumberselect 'Fraction'select the 1st option 'Upto
one digit (1/4))

If this post helps click Yes
---------------
Jacob Skaria


"Jack Deuce" wrote:

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
.

Help with formula
 

Just format as 0 0/#0

--
__________________________________
HTH

Bob

"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