Excel formula?
 

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

Excel formula?
 

Assume cell A1, change to fit your data:

=INT(A1/12)&"'"&MOD(A1,12)&""""

--
Regards,
Dave


"Shannon" wrote:

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

Excel formula?
 

Look in the help index for CONVERT

--
Don Guillett
SalesAid Software

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

Excel formula?
 

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

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