C
covdbrdg
How can I display a number as feet and inch in single cell, ie. 8.5 to
display 8'-6"
display 8'-6"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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.
=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")&"""")
=(TEXT(INT(A1),"0")&"' "&TEXT((A1-INT(A1))*12,"0")&"""")
C
covdbrdg
Thanks, but, How do I create a user defined function?
C
covdbrdg
I GOT IT FROM ANOTHER POST... I need to be able to do this in a singlt cell,
like formatting.
like formatting.