display number as feet and inch in single cell

C

covdbrdg

How can I display a number as feet and inch in single cell, ie. 8.5 to
display 8'-6"
 
B

bigwheel

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.
 
B

bigwheel

Or you could use a formula:-

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

covdbrdg

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

Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56) 6
Formula converts value into Feet, Inches & Fraction of an Inch 6
Averaging feet and inches (not decimal feet) 4
Seperating Feet, inches and fractions 5
decimal feet to feet-inch-sixteenths conversion 1
Display a number in feet inches and fractions of and inch 1
How to format feet/inches (ft'in") 4
Found few bugs in my daily routine of work in excel for MAC 0

Top