title: Rounding number from XML to Excel
body: <p>I'm reading some value from XML:</p>
  
  <pre><code>&lt;DocumentSetNumber&gt;20151027301060001&lt;/DocumentSetNumber&gt;
  
  $DSN = $xml.metaBI.DocumentSetNumber
  </code></pre>
  
  <p>and then writing to Excel using PowerShell:</p>
  
  <pre><code>$ExcelWorkSheet.Cells.Item($Row,1).Value2 = $DSN 
  </code></pre>
  
  <p>But in Excel I'm getting this number: 2.0151E+16</p>
  
  <p>If I change Excel format I can get this: 20151027301060000</p>
  
  <p>It's not the same number, and I need to get exactly the same.</p>
  
  <p>I tried to play with Excel formats and also use Tostring() on variable, but without luck.</p>
  
  <p>What also can I try? </p>
  
  <p>PS. If I copy and paste this value manually it works only I use </p>
  
  <blockquote>
    <p>match destination formatting</p>
  </blockquote>
  
  <p>option in Excel.</p>
  
  <p>How I can set this option from PowerShell?</p>