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

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

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

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

Jim Thomlinson


"cybergardener" wrote:

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

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

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

Dave
--
Brevity is the soul of wit.


"cybergardener" wrote:

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

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

=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

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

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


"Jim Thomlinson" wrote:

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

Jim Thomlinson


"cybergardener" wrote:

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

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

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

"cybergardener" wrote in message
...
That worked but now how do I make 69 show as 5'9" instead of 5.75
--
Thanks
Cyber Gardener


"Jim Thomlinson" wrote:

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

Jim Thomlinson


"cybergardener" wrote:

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