title: MS Excel scientific notation (example: 2.231321654E+01)
body: <p>I am editing a legacy Visual Basic 6.0 program. It reads from a GPIB instrument and obtains a raw string in scientific notation. For example:</p>
  
  <pre><code>2.231321654E+01
  </code></pre>
  
  <p>Another line in the program processes that string so that it would be suitable for input into the spreadsheet:</p>
  
  <p><code>Round(2.231321654E+01, 1)</code> returns <code>22.3</code></p>
  
  <p>I want to have 2 decimal places:</p>
  
  <p><code>Round(2.231321654E+01, 2)</code> <strong>should</strong> return <code>22.31</code>, but NO, it returns <code>22.3</code>. Why?</p>
  
  <p><strong>Another approach:</strong><br>
  I tried to bypass the <code>Round()</code> processing and have the program input the raw string directly into the spreadsheet. I still get <code>22.3</code></p>
  
  <p><strong>Yet another approach:</strong><br>
  I bypassed the program entirely and manually input <code>2.231321654E+01</code> into any cell in the spreadsheet. I still get <code>22.3</code></p>
  
  <p><strong>Summary:</strong><br>
  I want to write 2 decimal places into the spreadsheet. How do I do it? I think the original author manipulated the cell number properties to retain only up to one decimal place. How do I manipulate it? What should I look for in the code?</p>