i know there are a lot of posts and things on feet and inches. my question
is a little more specific. i want the format to be (for 11 feet 6 inches) to
look like 11-6. so far, my formulas look like this:

this formula would convert 11-6 to 11.6 feet
=IF(F4=0,0,LEFT(F4,FIND("-",F4)-1)+((MID(F4,FIND("-",F4)+1,LEN(F4)))/12))

then this formula converts it back to 11-6
=CONCATENATE(LEFT(AC4,FIND(".",AC4)-1),"-",ROUND(((MID(AC4,FIND(".",AC4),LEN(AC4))))*12 ,1))

the problem i am having is that if it is 11-0, the second formula returns an
error. i think it is because it can't FIND the "."

i would appreciate any help.

Steve