title: Bond Price fraction convert to decimal 32nd excel formula
body: <p>i am pretty sure a lot of people in capital market experience this :
  use excel formular to convert fraction to decial in 32nd</p>
  
  <p>i know most case we just divide last 2 digits decimal place by 32 for example:</p>
  
  <p>100-160= 100+16/32=100.5
  100-200=100+20/32=100.625</p>
  
  <p>but if 3 decimal places : 99-226=99+(22+6/8)/32=99.7109375</p>
  
  <p>how do we convert it to formula in excel , please help!!!!</p>