hi,
In one way ,it can be done as follows.
cells:- A1(given feet in decimals) B1(converted as total inches)
C1(feet portion only) D1(inches portion only)
In A1=10.333, B1=A1*12 , C1=int(B1/12), D1=mod(B1,12) give values
124 10 4
K.S.Warrier

"Gord Dibben" wrote:

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.