Subject: how to convert 112" to 9'4" with a formula in Excel

  • Thread starter Thread starter Mike H
  • Start date Start date
M

Mike H

Try

=INT(A1/12)&"'"&"-"&MOD(A1,12)&""""

Remeber to put the question in the body of your message because some of us
can't answer if you don't

Mike
 
Ditto what Mike said, you could also use the minimally used QUOTIENT
=QUOTIENT(A1,12)&"' "&MOD(A1,12)&CHAR(34)
 
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 inches & display as Feet Inches and Fractions -- BUG FREE 9
Formula Discrepancy 2
Converting from Decimal to Base-36 in Excel Formula 8
How to convert 120608 in Excel into 12 Feet 6 inches 8 sixteenths 12
How convert Numeric number in words 2
Formula Help Price Code 1
Formula to get number of days excluding Fridays in a given period 17
sheet formulas and strings 4

Back
Top