title: excel formula to convert to decimals of a foot
body: <p>i am trying to convert a number into decimals of a foot in excel.  here is my formula </p>
  
  <pre><code>=IF(C2="", "",ROUND(LEFT(C2,FIND("-",C2)-2)+SUBSTITUTE(REPLACE(C2,1,FIND("-",C2),""),CHAR(34),"")/12,4))
  </code></pre>
  
  <p>If Cell C2 is 41-9, it returns 4.75 
  it works fine except when excel automatically changes cell c2 to a date such as 8-8.  any ideas?</p>