title: Format cell from general to text
body: <p>I'm trying to write a little script that opens Excel, formats cell <code>B1</code> to text and saves the file, but I cant get "format to text" to work. Does someone know what I'm missing here?</p>
  
  <p>It's this line that isn't working: <code>ExcelObj.Cells("B").Value = "@"</code></p>
  
  <pre><code>Set ExcelObj = CreateObject("Excel.Application")
  ExcelObj.DisplayAlerts = False
  ExcelObj.Visible  = true    ' or false
  ExcelObj.Workbooks.Open "C:\Supplier\DK\ExternalPrices\Mapforcecode\Computercity\excelmapping\ExternalPrices.xlsx"
  ExcelObj.Cells("B").Value = "@"
  ExcelObj.Workbooks(1).SaveAs "\\file-srv1\Scalepoint\Supplier\Catalog\Data\DK\Computercity\Current\ExternalPrices.xlsx", 51
  ExcelObj.Quit
  </code></pre>