display number as feet and inch in single cell

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
Fractions, Feet, Inches, & macros 8
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
Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56) 6

Back
Top