| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=CONVERT(A2,"in","ft")
How can I convert inches to feet, I have tried =CONVERT(A2,"in","ft")
-- Thanks Cyber Gardener |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
