title: VBA format cells to General
body: <p>I would like to format a excel file to "General", but it's not working for all cells (some are custom, pourcentage...).
   here is my code :</p>
  
  <pre><code>With ActiveSheet.Range("A1").Resize(LineIndex, 1)
      .Value = WorksheetFunction.Transpose(strLine)
      .NumberFormat = "General"
      'DEFINE THE OPERATION FULLY!!!!
      .TextToColumns Destination:=.Cells(1), DataType:=xlDelimited, _
                     TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, _
                     Tab:=False, Semicolon:=False, Comma:=False, Space:=False, _
                     Other:=True, OtherChar:="|"
  </code></pre>
  
  <p>help please. </p>