View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jkrager
 
Posts: n/a
Default display feet and inches

Is there any way in excel to display feet and inches? I can get decimal feet
and even fractional feet ie. 3 1/3. Is there any way to multiply the
fraction portion of that by 12 to get it to spit out 4? Even if it ends up
in two differnet cells, I can get another cell to read 3 and the next cell to
read 4, and squash them together to look like 3'-4".