display number as feet and inch in single cell

G

Guest

You could do it with a user defined function e.g.

Function d_to_fi(numberarg As Double)
feet = Int(numberarg)
inches = Format((numberarg - Int(numberarg)) * 12, "#0")
d_to_fi = feet & " ' - " & inches & """"
End Function
 
D

Dave O

It can be done with a formula:
=INT(A1)&CHAR(39)&"-"&MOD(A1,INT(A1))*12&CHAR(34)
....but I don't know if there is a way to create a custom format to do
it.
 
G

Guest

Or you could use a formula:-

=(TEXT(INT(A1),"0")&"' "&TEXT((A1-INT(A1))*12,"0")&"""")
 
G

Guest

I GOT IT FROM ANOTHER POST... I need to be able to do this in a singlt cell,
like formatting.
 

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

adding feet and inches 6
Excel How To Convert Decimal To Inches 2
How to format feet/inches (ft'in") 4
Formula converts value into Feet, Inches & Fraction of an Inch 6
convert column with inches to 2 columns "feet" and "inches" 2
display feet and inches 2
Seperating Feet, inches and fractions 6
Fractions, Feet, Inches, & macros 8

Top