View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JB
 
Posts: n/a
Default How do I set a cell format for Feet and Inches? i.e. 3'-10 1/2"

How do I set a format in cells to display feet and inches as follows?

3'-10 1/2"

or

3-10 1/2