title: Change formatting of a column to text
body: <p>Every time I run this code the entire sheet becomes Text.</p>
  
  <p>I want to keep the rest of the sheet General, but change column A to Text. </p>
  
  <p>For the</p>
  
  <pre><code>Columns("A").Select _
    ActiveCell.NumberFormat = "@"
  </code></pre>
  
  <p>I tried</p>
  
  <pre><code> Range("A:A").Select
   Selection.NumberFormat = "@"
  </code></pre>
  
  <p>I tried writing it with the specific workbook instead of letting VBA assume the active worksheet and cells.</p>
  
  <p>I tried to NumberFormat the other columns to be General after running the formatting on column A.</p>
  
  <pre><code>Columns("A").Select
  Range("A1").Activate
  Selection.Delete Shift:=xlToLeft
  
  Columns("A").Select
  ActiveCell.NumberFormat = "@"
  Range("A1").Select
  ActiveSheet.Paste
  Application.CommandBars("Office Clipboard").Visible = False
  </code></pre>
  
  <p>I expected that if I put another line after my numberformat that I would be able to get column B:ZZ to all be General.</p>
  
  <p>I've gotten no error messages.</p>