Thread: formula to convert decimal feet to feet inch sixteenths
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Converting inches to feet + inches
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