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

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
 
J

John C

Ditto what Mike said, you could also use the minimally used QUOTIENT
=QUOTIENT(A1,12)&"' "&MOD(A1,12)&CHAR(34)
 

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

How to paste this down? 3
Want To Shrink Formula 1
How to center adjust text above and image in a two column document. 1
How do I convert shading to highlighting for specific colors 8
How convert Numeric number in words 2
Formula to get number of days excluding Fridays in a given period 17
How can you convert a text value to a numerical formula ? 16
in excel how can we put formula to convert numericalfigureto word 2

Top