Thread: Convert Decimal to Feet and Inches
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
  
Posts: 586
Default Convert Decimal to Feet and Inches
Is there a magic function that would format a decimal number to feet and
inches? For example,

MAGICFUNCTION(98.8125 inches) = 8'-2 13/16"
or
MAGICFUNCTION(8.234375 feet) = 8'-2 13/16"

--
Cheers,
Ryan
Reply With QuoteReply With Quote