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

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