Covert # to measurement

D

DbobThe Builder

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
 
J

John A

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?
 
D

David Biddulph

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