Thread: formula to convert decimal feet to feet inch sixteenths
View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
John A[_2_] John A[_2_] is offline
external usenet poster
  
Posts: 15
Default Converting inches to feet + inches
I'll try it Gord.
--
Thanks for your help


"Gord Dibben" wrote:

Enter the formula in B1 then enter your number 55 in A1


Gord Dibben MS Excel MVP


On Mon, 19 Nov 2007 19:11:01 -0800, John A
wrote:

Do I simply enter the formula you recommended into the formula bar in cell A1
(example) and then try entering an inches number 55 or 55" (in cell A1) and
it should convert to 4'7"?


Reply With QuoteReply With Quote