C
cybergardener
How can I convert inches to feet, I have tried =CONVERT(A2,"in","ft")
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.
J
Jim Thomlinson
What you have is correct... Just make sure you ahve installed the Analysis
Toolpack Addin... Tools -> Addins -> Analysis Toolpack (check)
Toolpack Addin... Tools -> Addins -> Analysis Toolpack (check)
D
Dave F
=6/12. Six inches is .5 feet, etc.
Dave
Dave
B
Bob Phillips
=A1/12 if you just want decimal feet.
If you want feet and inches, try
=INT(A1/12)&"ft "&MOD(A1,12)&"ins"
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
If you want feet and inches, try
=INT(A1/12)&"ft "&MOD(A1,12)&"ins"
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
C
cybergardener
That worked but now how do I make 69 show as 5'9" instead of 5.75
D
David Biddulph
See the reply from Bob Phillips. You'll have to play with the punctuation
to get the ' and "
to get the ' and "