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

"cybergardener" wrote in message
...
How can I convert inches to feet, I have tried =CONVERT(A2,"in","ft")
--
Thanks
Cyber Gardener