Thread: How do I display numbers as feet AND inches, as in x'x" ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orision Orision is offline
external usenet poster
  
Posts: 4
Default How do I display numbers as feet AND inches, as in x'x" ?
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