View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John A[_2_] John A[_2_] is offline
external usenet poster
 
Posts: 15
Default 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