formula for converting decimal to inch & fraction

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you provide a formula to convert a decimal to an inch & fraction?
I am using Excel 2000.
Thank you for your help.
 
select the cell and pull-down:

Format > Cells... > Fraction and the pick a suitable form.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert decimal inches into feet and inches 4
Excel How To Convert Decimal To Inches 2
convert decimal to inch & fraction 1
Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56) 6
Seperating Feet, inches and fractions 6
Convert Decimal fractions to binary and vice versa 1
How do I convert decimal inches to fractions in excel 2
How to format feet/inches (ft'in") 4

Back
Top