How do I set cell format for feet, inches, & fractions of inches?

[steve-b]

I need to set cell format to display feet & inches, with fractions (xx'-xx
x/x").

 

[Guest]

hi,
you can format to fractions but i am not aware of any
formaat that will handle feet and inches.

 

[Frank Kabel]

Hi
maybe the following helps you:
http://www.cpearson.com/excel/fractional.htm

 

[Gord Dibben]

steve-b

See Chip Pearson's site for formulas working with feet and inches.

http://www.cpearson.com/excel/fractional.htm

Gord Dibben Excel MVP