title: VBA macro date format
body: <p>I have a problem with date format in my VBA macro. 
  I am trying to create macro to analyze data log which I am getting from a robot which looks like this. </p>
  
  <pre><code>Counter_Red,"04/03/2019 12:54:19",3,1,43528537722.5347
  </code></pre>
  
  <p>At the beggining I need to split the data into separate columns before I can analyze them. 
  When I use excel tool for splitting text into columns it works fine and I get expected result in format day.month.year.</p>
  
  <pre><code>04.3.2019  12:54:19
  </code></pre>
  
  <p>I created macro to do the split for me.</p>
  
  <pre><code> Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
      TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
      Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
      :=Array(Array(1, 1), Array(2, 4), Array(3, 1), Array(4, 1), Array(5, 1)),   _
      TrailingMinusNumbers:=True
  </code></pre>
  
  <p>But when I use my VBA macro to do it, it always changes day and month so the resulting format is month.day.year. </p>
  
  <pre><code>3.4.2019  12:54:19
  </code></pre>
  
  <p>Can anyone please advice me how to fix it so my macro will give me correct date  format day.month.year?</p>