Thread: Change Inches to feet and Inches
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
  
Posts: 972
Default Change Inches to feet and Inches
I have a column adding inches with fractions like this:

96
4 1/4

100 1/4

How can you format the cell with 100 1/4 to show 8' 4" 1/4

Thank you for your help.
Reply With QuoteReply With Quote