feet and inches

[Corey]

Does anyone know how to format an Excel cell so you can
type in feet and inches and get a decimal equivalent of
vice versa? Example: typing 12.125 would give you
12'-1 1/2. Any help would be great.

 

[J.E. McGimpsey]

You might take a look at David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/formula.htm#carpentry