title: Excel VBA TextToColum working partly with MS Project Dates
body: <p>I am trying to parse the dates in an Excel sheet coming from MS Project.</p>
  
  <pre><code>11 May 2022 17:00
  13 May 2022 17:00
  23 July 2021 17:00
  </code></pre>
  
  <p>I am using </p>
  
  <pre><code>For Each c In Range("A1:ZZ1")
      If c.Value = "End" Then
  
          Columns(c.Column).TextToColumns Destination:=c.Columns, DataType:=xlFixedWidth, _
          FieldInfo:=Array(0, 4)
      End If
  Next
  </code></pre>
  
  <p>This works only for part of the cells, a lot stay as they were.
  Using the Excel menue function TextTo Column it works fine.</p>
  
  <pre><code>12 March 2021 17:00
  26.01.2022 17:00
  09.02.2022 17:00
  26 March 2021 17:00
  </code></pre>
  
  <p>Why could this happen?</p>
  
  <p>EDIT: I am on German language normally, but it works with some and some not.
  The weird thing is, it works fine with the standard Excel function, even with all German names.</p>