How to change decimals of length in feet to feet and inchs

  • Thread starter Thread starter John
  • Start date Start date
see your other post
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
If you are talking about showing your conversion in another cell, then you
can use this formula...

=INT(A1)&"'-"&12*MOD(A1,1)&""""
 
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

Conversions of Decimal Feet to Decimal Inches - Formula?? 0
adding feet and inches 6
Excel How To Convert Decimal To Inches 2
convert decimal inches into feet and inches 4
change decimal to feet and inches 10
formula to convert decimal feet to feet inch sixteenths 23
How to format feet/inches (ft'in") 4
decimal feet to feet-inch-sixteenths conversion 1

Back
Top