title: PowerShell Export-Excel - Format Cells As Text "@"
body: <p>When I run the below and open up the Excel file, I see that all the cells are formatted as Text but the number still appears as: 2.38742+12.  I'd like to see the actual value as Text: 0002387429384723.</p>
  <p>I'm using PowerShell 5.1 and the Export-Excel module with Excel 2016.</p>
  <pre><code>$xl = &quot;0002387429384723&quot; | Export-Excel -Path &quot;c:\temp\file.xlsx&quot; -WorksheetName &quot;Sheet1&quot; -Numberformat &quot;@&quot; -PassThru
  
  $xlSheet = $xl.Workbook.Worksheets[&quot;Sheet1&quot;]
  $xlSheet.Cells.AutoFitColumns()
  
  Close-ExcelPackage $xl
  </code></pre>
  <p>I'm not sure what I'm missing here.  Any guidance on this would be helpful.</p>