title: Powershell - Excel Change format of the column to Text
body: <p>I have to convert 2 columns in 20 excel files (same format) everyday. Is there a way in powershell to make it work. I searched for some examples but all point to change of Number format.</p>
  
  <p>Current code:</p>
  
  <pre><code>$worksheet.columns.item('d').NumberFormat = "$#,##0.00" 
  </code></pre>
  
  <p>The entire Workbook / Worksheet is in "General" format</p>
  
  <p>Help is appreciated.</p>