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")