Help with formula

[Jack Deuce]

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

 

[David Biddulph]

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()

 

[Jacob Skaria]

Right click>Format Cells>Number>select 'Fraction'>select the 1st option 'Upto
one digit (1/4))

If this post helps click Yes

 

[Bob Phillips]

Just format as 0 0/#0