Thread: How do I display numbers as feet AND inches, as in x'x" ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I display numbers as feet AND inches, as in x'x" ?
=TEXT(INT(A1),"0 '")&TEXT(MOD(A1,1)*12,"-0 \""")
--
Gary's Student


"Orision" wrote:

How do I get cells to display in feet and inches using the x'x" format? For
instance, instead of 16", display 1'4" . or, instead of 2.5', display 2'6"
I've tried to write my own custom number format to no avail, since I can't
figure out how to get a custom format to perform functions.
Reply With QuoteReply With Quote