title: VBA - how to convert a column to percentages
body: <p>I've a code that generates a utilisation formula, however, the output is being displayed in $ when I want it to be in percentages %.</p>
  
  <p>Does anyone know how to make this work via VBA? I know how to easily change this via normal excel but I would like this process to be automated if possible. </p>
  
  <p>What i have so far:</p>
  
  <pre><code>'Utilisation rates
  
  With ActiveSheet
      'Determine last row
      Dim lastrow2 As Long
      lastrow2 = .Cells(.Rows.Count, "F").End(xlUp).Row
  
      'Copy the original values from column A to column B
      .Range("H6:H" &amp; lastrow2).Value = .Range("F6:F" &amp; lastrow2).Value
  
      'Copy / Pastespecial Divide using cell C3
      .Range("C3").Copy
      .Range("H6:H" &amp; lastrow2).PasteSpecial Paste:=xlPasteValues, _
                                            Operation:=xlDivide, _
                                            SkipBlanks:=False, _
                                            Transpose:=False
      Application.CutCopyMode = False
  
  
  
  End With
  </code></pre>
  
  <p>Thank you!!! (:</p>