=CONVERT(A2,"in","ft")

[Guest]

How can I convert inches to feet, I have tried =CONVERT(A2,"in","ft")

 

[Guest]

What you have is correct... Just make sure you ahve installed the Analysis
Toolpack Addin... Tools -> Addins -> Analysis Toolpack (check)

 

[Guest]

=6/12. Six inches is .5 feet, etc.

Dave

 

[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)

 

[Guest]

That worked but now how do I make 69 show as 5'9" instead of 5.75

 

[David Biddulph]

See the reply from Bob Phillips. You'll have to play with the punctuation
to get the ' and "