Have a look at Chip Pearson's site for working with feet and inches using the
ATP DOLLARDE and DOLLARFR functions.

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

Gord Dibben Excel MVP


On Wed, 3 Nov 2004 13:06:03 -0800, "rebar"
wrote:

IS there a macro or formula to enter 10.333' as 10'-4" or 10-04.