Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Covert # to measurement
I've been working my way through these posts and installed Analysis ToolPak
on my Excel 2003. What I really want to do is to be able to have Excel covert just inches (61") or (61) into feet and inches. How do I proceed in a work sheet? -- Thanks for your help "DbobThe Builder" wrote: I want to convert a number with decimal (23.5) to feet and inches (23' 6") I cant figure out how to multiply just the decimal place (.5) by 12 and then show the quotation marks(" ') which designate feet and inches |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Covert # to measurement
=INT(A1/12)&"' "&MOD(A1,12)&""""
which doesn't need analysis ToolPak. The recommendation in the thread (from June 2004!) to which you referred was if you wanted to use =DOLLARFR(A1/12,12) to get the output as 5.01 -- David Biddulph "John A" wrote in message ... I've been working my way through these posts and installed Analysis ToolPak on my Excel 2003. What I really want to do is to be able to have Excel covert just inches (61") or (61) into feet and inches. How do I proceed in a work sheet? -- Thanks for your help "DbobThe Builder" wrote: I want to convert a number with decimal (23.5) to feet and inches (23' 6") I cant figure out how to multiply just the decimal place (.5) by 12 and then show the quotation marks(" ') which designate feet and inches |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set measurement | Excel Discussion (Misc queries) | |||
Covert Data the comes for a CVS | Excel Discussion (Misc queries) | |||
Do anyone know how to covert 912:30:44 into seconds | Excel Discussion (Misc queries) | |||
covert 72.8 to 72:48 | Excel Worksheet Functions | |||
how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2 | Excel Worksheet Functions |