Covert # to measurement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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