FORMAT FOR FEET AN DINCHES
 

Is there any way to easily format for feet and inche?

FORMAT FOR FEET AN DINCHES
 

1) Suppose A1 contains a value such as 63 to represent 63 inches, then the
formula
=INT(A1/12) & " ft. " & MOD(A1,12) & " in."
will display 5 ft 3 in. But this is TEXT and you can do not math on it

2) I find it better to enter, for example, 5 3/12 and to format the range
with custom format # ?/12
You can do all the math you need on such cells

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Roys31" wrote in message
...
Is there any way to easily format for feet and inche?

FORMAT FOR FEET AN DINCHES
 

See http://www.cpearson.com/Excel/FractionalArithmetic.aspx


Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]


On Wed, 13 Jan 2010 09:29:01 -0800, Roys31
wrote:

Is there any way to easily format for feet and inche?