title: Binary to Decimal conversion for 27 digits
body: <p>I am trying to convert binary digit that is 27 characters long</p>
  
  <pre><code>BIN2DEC(B2) 
  </code></pre>
  
  <p>Didn't work</p>
  
  <p>I also tried</p>
  
  <pre><code>=BIN2DEC(MID(B3,1,9))&amp;BIN2DEC(MID(B3,10,9))&amp;BIN2DEC(MID(B3,20,9))
  </code></pre>
  
  <p>The number I am trying is </p>
  
  <pre><code>001010011100101110111110101
  </code></pre>
  
  <p>The answer I am getting is </p>
  
  <pre><code>83302491
  </code></pre>
  
  <p>Where as the right answer is </p>
  
  <pre><code>21913077
  </code></pre>