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)
 
Back
Top