software

Is there a formula to convert inches to feet? (Ex: 67quot; to 5'7quot; and 75quot; to 6'3quot;)

Assume cell A1, change to fit your data:

=INT(A1/12)amp;quot;'quot;amp;MOD(A1,12)amp;quot;quot;quot;quot;

--
Regards,
Davequot;Shannonquot; wrote:

gt; Is there a formula to convert inches to feet? (Ex: 67quot; to 5'7quot; and 75quot; to 6'3quot;)

Look in the help index for CONVERT

--
Don Guillett
SalesAid Software

quot;Shannonquot; gt; wrote in message
...
gt; Is there a formula to convert inches to feet? (Ex: 67quot; to 5'7quot; and 75quot; to
gt; 6'3quot;)
Use the formula =A1/12 and format the cell with custom format # ??/12
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Shannonquot; gt; wrote in message
...
gt; Is there a formula to convert inches to feet? (Ex: 67quot; to 5'7quot; and 75quot; to
gt; 6'3quot;)